It took me more than 9 hours to respond back every single email, I had received on this topic. Here are the Top 3 Wait Stats from Real-World.
I finally decided to create a video on that topic on my SQL in Sixty Seconds Channel. I will create more videos on the topic Wait Stats for Performance.
I have updated my SQL Wait Stats Collection Script for my clients. In today’s blog post we will be looking at the newly updated SQL Wait Statistics Script.
I strongly suggest that you first watch it before we continue on today’s topic of SQLOS Scheduler and the Process States.
Recently one of my clients asked if I know a way to find the Wait Statistics from the Query Execution Plan. Yes, there is a way to do it.