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.