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

First Name*
Last Name*
Business Email*
Company*
Phone Number*
Country*
State Province
Hidden
Order Type
Hidden
Topic
Hidden
Source
Hidden
Medium
Hidden
Campaign
Hidden
Content
Hidden
Search Term
Hidden
ProdInterestArea
Hidden
ProdInterestArea_AF
Hidden
Website Source
Hidden
Redirect URL
term agree
- I have read, understand, and agree to AquaFold, Inc. - AquaFold Terms of Use & Privacy Statement .
term read
- I agree to receive marketing communication from AquaFold, Inc. - AquaFold for product updates, sales services, promotions, news, and events. I can withdraw my consent at any time and update my communication preference at the subscription center from any email received.
Hidden
Term hidden
Note: By filling and submitting this form you understand and agree that the use of AquaFold’s website is subject to the General Website Terms of Use. Additional details regarding AquaFold, Inc. collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.

Webcast Form

First Name*
Last Name*
Business Email*
Company*
Phone Number*
Country*
State Province
Hidden
Order Type
Hidden
Topic
Hidden
Source
Hidden
Medium
Hidden
Campaign
Hidden
Content
Hidden
Search Term
Hidden
ProdInterestArea
Hidden
ProdInterestArea_AF
Hidden
Website Source
Hidden
Redirect URL
term agree
- I have read, understand, and agree to AquaFold, Inc. - AquaFold Terms of Use & Privacy Statement .
term read
- I agree to receive marketing communication from AquaFold, Inc. - AquaFold for product updates, sales services, promotions, news, and events. I can withdraw my consent at any time and update my communication preference at the subscription center from any email received.
Hidden
Term hidden
Note: By filling and submitting this form you understand and agree that the use of AquaFold’s website is subject to the General Website Terms of Use. Additional details regarding AquaFold, Inc. collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.