Introduction to Query Tuning on Microsoft SQL Server


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

Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at blogs.sentryone.com/author/kevinkline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Companies with the highest demands for database performance choose SentryOne