Performance Troubleshooting made easy with PAL

Performance troubleshooting is a key aspect of any operational DBA's role and identifying performance bottlenecks quickly enables faster problem resolution. 

PAL helps identify problems quickly by processing large log files and providing a colour-coded report highlighting problem areas.

Here's a summary of the session:

  • Performance troubleshooting
    • Troubleshooting methodology
    • Data capture
  • Using Performance Analysis for Logs (PAL)
    • Analysing PerfMon log files
    • Tuning thresholds
    • Working with theshold templates
  • Post-analysis steps
    • Establish a baseline
    • Next steps for troubleshooting
Presented by Justin Langford at SQLBits VI
  • Downloads
    Video available WMV Video 166 MB
  • 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