The very first script which I sent to my clients during Comprehensive Database Performance Health Check is SQL Wait Statistics. I have recently updated my SQL Wait Stats Collection Script for my clients.
In this video, I discuss three different methods of how you can get started with Wait Stats for Performance.
- Do it yourself by following the blog post here which contains all the important links: SQL SERVER – Wait Stats – Wait Types – Wait Queues – Day 0 of 28
- Send me an email at firstname.lastname@example.org and I will reply back in 24 hours.
- You can post details about the wait stats on various online forums to get expert help.
As the wait statistics information does not contain any schema or data information, it is perfectly safe to send that to anyone without sharing your private information.
Reference: Pinal Dave (https://blog.sqlauthority.com)