Boris Hristov

Founder of 356labs

Founder of 356labs
and PowerPoint MVP.
Speaker, Trainer & Author.
A guy that loves to do sports, have fun and enjoy life. Gallery / Blog / Contact

Copyright © 2019 ·

SQL Server Wait Stats.
The way to learn them!

September 3, 2015 By Boris Hristov Leave a Comment

If there is one problem SQL Server DBAs are struggling with on a day-to-day basis, that’s performance! I am absolutely, 100% sure you have heard – “It is slow!”. Or one of my other favourites – “This was performing better last time I checked it!”.  pro_wait_stats_cover_enriko

As such, database admins are in a very interesting position every single time when someone says one of the above. However, in order for the DBA to understand what’s going on inside SQL Server and troubleshoot efficiently, he has to understand one very important thing – the wait statistics. The so called wait stats are one of the first (if not the first) thing that experienced DBAs are looking at whenever performance issues arrises.

A lot has been written on the web about wait stats and how to use them properly. However, up until now there was no single place where you can find detailed information together with examples on every wait stat that you can face in your work as a DBA. And before letting you know about the book itself, I am extremely happy to say that it is a friend of mine – Enrico van de Laar(t|b) who put his heart and soul into bringing this extensive knowledge to you. Enrico is not just the author of this book, but also quite experienced DBA and widely recognized speaker who is based in the Netherlands. So if you trust me, you have no reason to not trust this guy! He really understands what he is talking about!

Now, the book! It’s just a must have – for both junior and senior DBAs! I am staying behind my words because what Enrico did is not just explaining and showing to you all the most important wait stats and what they mean for your system, but he went beyond that because inside his book, you will be able to find information about wait statistics that currently no one has written and commented about. One example are the waits around Hekaton tables…

So if you were wondering what SQL Server book to order next or you just want to become better in your work as a DBA, just go to Amazon and preorder the paperback Pro SQL Server Wait Statistics by Apress(or purchase the e-book version from the Apress website here now!). You will learn a ton!

Filed Under: SQL Server Tagged With: Books, Performance Tuning, SQL Server, SQL Server 2012, SQL Server 2014, Waits