Performance Troubleshooting made easy with PAL with Justin Langford

Platinum Sponsors

Travel & Accommodation

SQLBits 9 Query across the mersey

SQLBits 8 Beside the seaside

SQLBits 7 Wonders of SQL

SQLBits The 6th Sets (VI)

SQLBits Goes West (V)

SQLBits goes Forth (IV)

Gold Sponsors

Silver Sponsors

Bronze Sponsor

It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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

WMV Video 166 MB
SpeakerBIO

Justin Langford

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.
Video