Collection of Baseline Scripts

The topic of baselines in SQL Server is one that I’ve had an interest in for a long time.  In fact, the very first session I ever gave back in 2011 was on baselines.  I still believe they are incredibly important, and most of the data I capture is still the same, but I have […]

Capture Blocking Information with Extended Events and the Blocked Process Report

I am a big fan of Adam Machanic’s WhoIsActive script, and when customers have issues with performance, it’s one of the first tools I recommend because it’s so simple to use and provides great information.  Very often it helps with quickly determining an issue, but sometimes there’s a need to capture more information, particularly when […]

Let’s Get Ready to Summit!

Friends…the conference season is upon us (and could I have thought up a cheesier title for this post?!).   In less than two weeks the PASS Summit kicks off in Seattle and I am very much looking forward to a week of all things SQL Server. I will be in Seattle a full week, but […]