How to Troubleshoot a Slow Running Query in SQL Server (Extended Events & Wait Stats)

There are many ways how you can troubleshoot a slow-running query. One technique is to capture the wait stats for the query. Waits? What are those? In most simplistic terms, either your query is running...
December 14, 20170 Downloads⬇ Download