Most common wait stats over 24 hours and changes since 2010

Back in February I kicked off a survey asking you to run code that created a 24-hour snapshot of the most prevalent wait statistics. It’s taken me a few months to provide detailed feedback to everyone who responded and to correlate all the information together. Thanks to everyone who responded! I did this survey because I […]

Survey: target uptime – planned and actual

It’s been five years(!) since the last time I asked about your target uptimes for your critical SQL Server instances and I think we’d all be interested to see how things have changed. Edit 6/2/14: The survey is closed now – see here for the results. So I present four surveys to you. For your […]

Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types

In many of the sets of wait statistics I’ve been analyzing, the IO_COMPLETION and WRITE_COMPLETION waits show up (but never as the most prevalent wait type). The official definition of these wait types are: IO_COMPLETION: Occurs while waiting for I/O operations to complete. This wait type generally represents non-data page I/Os. Data page I/O completion waits appear […]

SQLskills community mentoring – round 6

We’ve had a mentoring program here at SQLskills for a few years (the brainchild of Jonathan), where each of us can pick someone who’s attended one of our Immersion Events in the past and offer to be their mentor for six months. It’s time to kick off the fifth mentoring session. You can read about […]