Brent Ozar
brentozar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.
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