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.
(no tags)
- Downloads
Sorry, there are no downloads available for this session.
- SpeakerBIO
Justin is a Principal Consultant for Coeo, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for SQL Server. Coeo also offer Remote DBA services for SQL Server platform. Prior to Coeo - Justin spent 3 years working for Microsoft as a Premier Field Engineer during which he delivered SQL Server support consulting to some of Microsoft’s largest finance and government customers. Justin co-authored Wrox IT Pro: SQL Server Performance Tuning, two Syngress exam guides on SQL Server 2008 and contributed to SQL Server 2008 Internals and Troubleshooting guide with Christian Bolton, Brent Ozar and James Rowland-Jones.
- Video
The video is not available to view online.
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.