29th - 31st March 2012

Novotel London West, London

Platinum Sponsor
RSS
Login or Join
Skip Navigation Links
Skip Navigation Links
Home
Content
Speakers
SQLBits X
Register
Agenda
Booking & Pricing
Training Day
Friday
Submit a Session
Sessions
Speakers
FAQ
Travel & Accommodation
Platinum Sponsor
Sponsorship
Gold Sponsors
Exhibitors
News
Previous Events
SQLBits Query across the mersey
SQLBits Beside the seaside
SQLBits 7 Wonders of SQL
SQLBits The 6th Sets (VI)
SQLBits goes West (V)
SQLBits goes Forth (IV)
SQLBits Cubed (III)
SQLBits II The SQL
SQLBits I
About
About SQLBits
Who's Who
Privacy
Ts&Cs
Contact
Community

Copyright © 2012 SQLBits. All Rights Reserved.

Telerik

Orcsweb

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
    justinlangford_cropped_PASS.jpg

    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 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.
    http://sqlblogcasts.com/blogs/justinl
  • Video

    Click here to view in local media player

  • Session Files Explorer
    •  Performance_Troubleshooting_made_easy_with_PAL
    0