GilaMonster (3/8/2013)
allmhuran (3/8/2013)
GilaMonster (3/8/2013)
sys.dm_os_wait_stats
Most of those are meaningless waits, background processes that are supposed to be waiting. That list says nothing of any value.
Yep, that's kinda the point I'm making by noting that iolatch is down at 12th under all of this. 🙂
You're missing my point. Those waits are ones you ignore completely. Saying that IOLatch waits are 12th under that list means they're the second top useful wait in the system. Those background waits are normal and expected to be high, they're from processes that spend most of their time doing nothing, so you just filter them out of any wait analysis.
No, I get your point, I'm just making it explicit that there's nothing particularly unusual at the top end of the list.
Regarding log entries: Yes, there are lots of cache flush messages, I understand this is now on by default for the checkpoint process to log without a trace flag.
- "FlushCache: cleaned up 2037 bufs with 1673 writes in 86339 ms (avoided 1002 new dirty bufs) for db 7:0"
- "average throughput: 0.18 MB/sec, I/O saturation: 3196, context switches 7021"
But I'm curious where you might be going... are you thinking a recovery interval issue, or perhaps this?:
http://blogs.msdn.com/b/joaol/archive/2008/11/20/sql-server-checkpoint-problems.aspx
Edit:
I might as well note here that I'm also getting appdomain unloads and messages indicating long IO requests, but I figured that was already a given based on numbers already posted.