Gems to help you troubleshoot query performance
BPCheck came to be back in 2011, as a way to empower Microsoft support engineers onsite with customers to gain insight on best practices not being followed, and evolved to include performance based checks. But this previously internal BPCheck script was released to Microsoft SQL Server GitHub recently and is now free to use. In this session you will learn how to leverage it for a comprehensive perf and health check of your SQL Server instance.
How to read the information, how to interpret results, how to use it for a quick health check, or a full comprehensive performance check as well.