SQL Server Performance Troubleshooting Techniques

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.

See http://www.sqlserverfaq.com/events/182/SQL-Server-Performance-Troubleshooting-Techniques-Sponsored-by-Quest-Software.aspx