Happy Monday! I'm sure many of you may have already caught on, that Waits & Queues is the way to go over previous performance analysis methodologies. With wait stats, you can directly pinpoint the bottleneck and see exactly what it is that SQL Server is waiting on, which resources, and whether the contention has to do with IO, CPU, Memory, Disk, or other. I have presented and blogged on the topic before, and was surprised how many DBAs have not heard about it, since it being made public in the release of SQL Server 2005 and its relevent DMVs.
I may be late to the fair, but I wanted to share what my friend and SQL Server expert also discovered, and has been working with since - Waits & Queues performance tuning. Pinal Dave, of SQLAuthority.com, has set out to bring us 28-days of everything we need to know about the topic. This excellent blog series, includes hints, tips, tricks, scripts and notes from the field, where his real-world experience shows us that it truly is something us DBA's cannot be without. It's a topic near and dear to my heart, and I'm glad Pinal has wrote about this and share it all with you!
We're up to Day 6, but no worries, we can read all his entries here: Wait Stats Blog Series Many fellow experts and MVP's have wished him luck, look forward to what he comes up with, and even cautioned that its a lot of work! But, nonetheles, Pinal is up to the challenge, and I am confident he can and will deliver. There are over 400 wait types, but I'm sure he will focus on the most common and relevant ones. Luckily for him, he picked February, with 28 days, since it is the shortest month of the year :-)
Read Pinal's first blog entry on Introduction to Wait Stats and Wait Types .
Now, I have some catching up to do.......