Leeds Area SQL Server User Group Meeting, Leeds - Wednesday 3rd June - Sponsored by Quest Software
End-to-End SQL Server Performance Troubleshooting – Iain Kick
When attempting to diagnose a problem in a SQL Server application, there's no right or wrong way to go about troubleshooting. However, certain techniques yield much better results when used for end-to-end troubleshooting.
This presentation will teach you the best practices for finding the root cause of a problem in a SQL Server application, correlating that root cause to a specific set of activities being performed on the server, and tuning the problem activity for maximum performance-all using the native SQL Server tools. We will then compare and contrast those techniques to Quest Software's performance management and query tuning tools. All examples and syntax are verified for Microsoft SQL Server 2005.
Specifically, after attending this presentation, you should have a good understanding of:
How to begin a troubleshooting project, including where to start and what to look at inside of SQL Server
How to use the query tuning tools and techniques available with the Microsoft tool kit, including the SQL Server Error Log, Windows Performance Monitor (PerfMon), SQL Server DMVs (and system tables in older versions of SQL Server), SQL Profiler, and SQL Server Management Studio's Graphic Explain Plan
How to use basic Transact-SQL statements to troubleshoot the performance of a SQL statement or Transact-SQL batch
Please note: although Iain will demonstrate how Quest has solved some of the problems within their products this session will not be a product demonstration.
Iain Kick is SQL Server systems consultant with more than eight years of experience working with complex database environments starting with Microsoft SQL Server version 6.5. He is currently the lead consultant for Quest Software's SQL Server business in the United Kingdom and in this role is responsible for pre- and post sales support and technical guidance including understanding the business drivers of Quest's customers and delivering effective solutions and expertise, technical guidance and implementation support to address customer requirements. Prior to joining Quest in 2005, Iain was a production DBA for Framlington Group and ITouch PLC. He is involved in and supports the SQL Server community as an author and speaker, and has presented at various industry events including SQLBits, regional user groups, to Microsoft TS teams and at Quest product launches and customer events all over Europe. Iain specialises SQL Server performance, tuning and backup/recovery. He graduated from Nottingham Trent University in 1999 with a degree in computer studies.