Webcast : Troubleshoot Performance and Tune Queries for SQL Server

How do you 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. 

SQL Server performance is important because it has a direct impact on the efficiency and effectiveness of database management. Excellent performance can save time and money by ensuring that database professionals can focus on keeping the system up and running well. Tuned SQL Server performance can also prevent hardware-related performance issues, leading to a more reliable infrastructure.

SQL Server query tuning is important because it helps optimize how queries perform, leading to faster and more efficient database operations. By identifying and improving slow queries, query tuning can reduce the time it takes for applications to access and process data, resulting in a better user experience and improved resource utilization. This can lead to cost savings and better overall system performance.

About the Presenter

K. Brian Kelley is a SQL Server author, columnist, and Microsoft MVP focusing primarily on SQL Server and Windows security. In addition to being a database administrator, he has served as an infrastructure and security architect encompassing solutions with Citrix, virtualization, and Active Directory. Brian is also a Certified Information Systems Auditor (CISA) and has been the head of a financial organization’s computer incident response team. Brian is active in the IT community having spoken at DevConnections, SQL Saturdays, code camps, and user groups. He is also the President of the Midlands PASS Chapter, a Professional Association for SQL Server Chapter located in Columbia, SC.

Please register to view the webcast replay.

Webcast Form

  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • You can always update your communications preferences later.
    AquaFold may share your information with its subsidiaries and its partners. For further details on how your data is used and stored, please review our Privacy Policy
  • Note: By registering, you confirm that you agree to the processing of your personal data by AquaFold, Inc. - AquaFold as described in the Privacy Statement. AquaFold, Inc. - AquaFold is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.

Webcast Form

  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • You can always update your communications preferences later.
    AquaFold may share your information with its subsidiaries and its partners. For further details on how your data is used and stored, please review our Privacy Policy
  • Note: By registering, you confirm that you agree to the processing of your personal data by AquaFold, Inc. - AquaFold as described in the Privacy Statement. AquaFold, Inc. - AquaFold is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.