Speaker: Kevin Kline
Bio:
Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com. As a noted leader in the IT industry, Kevin’s blog covers Microsoft SQL Server features and best practices, third-party software, trends in the IT industry, and professional development for IT professionals.
Session Title:
FIRE! A Full-proof Checklist for Tuning and Troubleshooting
Abstract:
Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.
In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:
- XEvents, Profiler/Traces, and PerfMon
- Using Dynamic Management Views (DMVs)
- Advanced Diagnostics Using Wait Stats
- Reading SQL Server execution plan
Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.
In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:
- XEvents, Profiler/Traces, and PerfMon
- Using Dynamic Management Views (DMVs)
- Advanced Diagnostics Using Wait Stats
- Reading SQL Server execution plan
Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.
Thank you to our Sponsors!