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.
Presented by Justin Langford at SQLBits VI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Justin_Langford.jpg

    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 mission critical SQL Server platforms.  Justin is an MVP and co-authored Wrox IT Pro: SQL Server 2012 Internals and Troubleshooting, as well as the same title for SQL Server 2008 and SQL Server 2005 Performance Tuning.

    http://sqlblogcasts.com/blogs/justinl
  • Video
    The video is not available to view online.