Tue, Jan 24 2017 11:00 UTC
FIRE! A FULLPROOF CHECKLIST FOR TUNING AND TROUBLESHOOTING
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 plans
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.
Kevin Kline is a noted database expert and software industry veteran. A long-time Microsoft Data Platform MVP and noted community leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server, as well as the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide and has a monthly column at Database Trends magazine. He tweets at @kekline and blogs regularly. Kevin is the Director of Engineering Services at SentryOne, a leading vendor of database tools.
Kevin Kline is a database expert and Technology Evangelist at SQL Sentry, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin's best known book is the best-selling "SQL in a Nutshell" and contributes monthly for Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/KevinKline.
JOIN PASS then add our Virtual Chapter to your list
Please join our chapter by creating a user account. This can be accomplished by clicking here. All registered users will be emailed detailed instructions prior to each meeting. Thanks!
Present to our Chapter
* Send us an abstract, and your biography to DBAFundamentals@sqlpass.org
* Put Speaker Request in the Subject
* Be patient and we will get back to you. We get a lot of emails.
Meetings At A Glance
Event Registration Link
ANSWERING THE QUESTION, “WHAT HAPPENED?” WITH QUERY STORE
Partitioning Basics: Treating your tables like Lego
Stored Procedure Optimization Techniques
Performance Troubleshooting Using Wait Statistics
SQL Tiger Team
“To be Determined”
Deadlocking for Mere Mortals
Dr. DMV’s Troubleshooting Toolkit