Summary:
You’ve started to write your own SQL statements, and it’s exciting to see the results returned from those statements. However, it can be difficult to tell if those SELECT statements are running well or just running to completion. How do you know if a query is running efficiently? What metrics and indicators tell you when a query is misbehaving?
Join query tuning expert Kevin Kline as he walks you through how to assess query performance, guarantee consistent query tuning, and avoid common performance killers in SELECT statements running on Microsoft SQL Server and Azure SQL Database. Kevin will show you query tuning with both SSMS and the free tool Plan Explorer.
This session takes you through a variety of live query tuning demonstrations that show you powerful ways to assess the performance of your queries. You will leave this webinar with an understanding of how to:
- Collect and interpret a variety of important query metadata
- Identify queries CPU, IO, and wait statistics
- Review a query execution plan
- Look for red flags in the execution plan and in other query metadata
- And much more!
Interested in additional SentryOne webinars? Check our webinar library.
Available On Demand
