Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
G33kKahuna
Starting Member
1 Post |
 Posted - 2009-12-09 : 14:29:18
|
| I am supporting a heavy read relatively low write SQL connected Enterprise application. Recently, we ran into some slowness. Of the many, I captured file stats (dm_io_virtual_file_stats) end of every day on a 24 hour cycle to understand file usage. I see that the LDF has 190K reads with 19G data read. What's perplexing is what would force such a heavy read from the LDF? I can think of log shipping but not configuredany other input is much appreciated.. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
What SQL activities would result in LDF reads?