On September 13, 2018, at 3 PM Eastern (USA), I’ll be giving a webcast for MSSQLTips.com on finding and correcting poorly performing queries.
Sign up link: SQL Server Performance Troubleshooting and Query Tuning
This is a 100-level webcast, but we’ll be looking at what we have within SQL Server to try and spot the issues and bring about solutions.
Here’s the abstract:
How do go about finding poorly performing SQL Server queries in your environment? And once you find them, what can you do about them?
In this webinar, Brian Kelley will show you the built-in functionality within SQL Server that will help you identify these problem queries on your system. We’ll also look at some cases where SQL Server is collecting data which may reveal an issue even if you don’t happen to catch the query in flight. Finally, we’ll look at the steps to tuning those queries so your overall system will perform better.