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!