Free tools for troubleshooting SQL Server performance
This session will be useful for anyone responsible for troubleshooting SQL Server performance problems.
The session provides details on when and how to use the PerfStats scripts to co-ordinate SQL Trace and PerfMon data capture and SQL Nexus for trace analysis. These tools are completely free to use and make analysis of huge trace files trivial.
These tools provide reports and drill-down analysis for performance troubleshooting and are an invaluable tool for rapid problem diagnosis.
Following this session, attendees will be familiar with the PerfStats and SQLNexus troubleshooting tools, knowing where to get the tools, when to use them and how to interpret the results.
Speaker focus
Justin is a Principal Consultant for Coeo Ltd, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for all versions of SQL Server. Coeo also offer Remote DBA services to customers who outsource management and 24x7 operations of their SQL Server platform. Justin works delivering and maintaining SQL Server solutions for customers in a variety of industry sectors throughout Europe.
Prior to joining Coeo - Justin spent three years working for Microsoft as a Premier Field Engineer. In this role, he delivered SQL Server support consulting to some of Microsoft’s largest finance and government customers in Europe. Justin has co-authored Wrox IT Pro: SQL Server Performance Tuning, two Syngress exam guides on SQL Server 2008 and contributed four chapters to the recently released Wrox SQL Server 2008 Internals and Troubleshooting guide with Christian Bolton, James Rowland-Jones, Jonathon Kehayias and Brent Ozar.
Other sessions from this conference