Sunday, January 5, 2014

SQL 2012 Wait Types

Checking over a 2012 instance today, I happened upon a couple of wait types I had not seen before.
Despite the particular VM being freshly configured and having a workload of basically nothing, 2 wait types found themselves in pole position according to my script.


In short, they are -

DIRTY_PAGE_POLL - A wait type associated with SQL 2012's Indirect Check Points.

HADR_FILESTREAM_IOMGR_IOCOMPLETION - A wait that is associated with checking the health of an Always On instance. It turns out it can be ignored if Always ON  is not being used.

So. time to update my waits scripts it would appear, and checking Brent Ozar's sp_blitz, he already has :)



No comments: