Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works

Ever have your SQL Server slow down for reasons that you can't explain?  Or did you spend all night tuning a query to perfection only to have it bog down in production?  Want to find out what's going on?  If so, read on... This week, I'll be presenting my session "What Are You Waiting For … Continue reading Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works

TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay

I’ve been meaning to join in on the T-SQL Tuesday event for the last couple months and let the time opportunity slip by.  This month’s topic is reporting and its seems like a good time to get in on the event. The great thing about reporting is that for the past few months I’ve been … Continue reading TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay

Wait Stat Categories

A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients.  I had promised to follow-up with a couple or three reports that could be used to monitor the values that were being aggregated in those tables. Before getting … Continue reading Wait Stat Categories