SQLBits 2015

Easy Performance Tuning: an Intro to Wait Statistics

You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics - the dramatically easier way to find your SQL Server's bottleneck. You'll learn:
  • How to collect wait stats data in thirty seconds (no, seriously)
  • How to interpret confusing results like CXPACKET and PAGELATCH
  • How to explain the results to clients, end users, and developers