Lots of people ask me how to stay in touch with SQLAuthority.com. Well, the answer is very simple, you can subscribe to the newsletter of SQLAuthority.com by going to URL here: https://go.sqlauthority.com.
I also want to make sure that I do not send you any spam hence once you subscribe it will send you an email where you will have to confirm that if you really want to sign up for this email or not. Once you sign up for the free newsletter, you get an instant reward for signing it up.
In your email box, you will get the following queries:
- Script to identify unused indexes and guidance
- Script to identify missing indexes and guidance
- Script to identify when was your last statistics updated and guidance
- Script to measure your SQL Server Wait Statistics
The latest versions of SQL Server has quite a lots of information about SQL Wait Statistics and you can read my blog post series written over here to learn more about it. SQL SERVER – 28 Links for Learning SQL Wait Stats from Beginning. If due to any reasons, you do not understand what actually your top wait statistics is and if you want help to understand it more you can always send me an email and I will be happy to answer you.
Here are two of the important questions related to Wait for statistics:
Q: The series which you have written two years ago, is it still relevant to the latest SQL Server?
A: Yes, absolutely. Everything which I have written earlier is still relevant to the latest version of SQL Server. The matter of the fact, most of it will remain relevant forever.
Q: Is SQL Wait Stats a good logical starting point for SQL Performance Tuning?
A: I believe so. It gives you a good idea where exactly your bottleneck is in your server.
Here is the link to signup for the newsletter: https://go.sqlauthority.com
Reference: Pinal Dave (https://blog.sqlauthority.com)