Performance Troubleshooting made easy with PAL

2010

TL; DR

If you've ever needed to review large Performance Monitor (PerfMon) logs and find problems quickly - you'll know how time consuming it can be to identify problems. Performance Analysis for Logs (PAL) is a great tool to quickly highlight performance problems - taking the leg-work out of PerfMon log analysis.

Session Details

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