Title: SQL Server Troubleshooting: Beginner, Intermediate, and Advanced
Level: 200, 300, and 400 respectively
Abstract: Finding and fixing problems in SQL Server is not an easy job. These sessions compress many years of hard-won experience from the industry’s best database administrators into three distinct sessions.
- Session 1 takes you from the position of a beginning IT technologist with limited SQL Server experience and teaches you the 80/20 rule of troubleshooting, including basic techniques, methodology, and the first four places to check for problems with will resolve as much as 80% of common SQL Server problems.
- Session 2 takes you from the position of understanding the basics of SQL Server troubleshooting to a deeper understanding of native tools, including Windows System Monitor and SQL Profiler, so that you can detect and diagnose a root-cause for problems that are more difficult to pinpoint.
- Session 3 takes you even deeper into the native SQL Server toolkit showing you how to use wait stat analysis to identify SQL Server’s most pernicious problems.
By learning the methodology as well as the specific techniques and features described in these three sessions, you will learn how to keep your SQL Server systems problem free and means of responding to problem situations such that problems are fixed before users ever experience issues and overall corporate user satisfaction increases.
Prerequisites: Basic understanding of SQL Server operations and activities – such as transactions, queries, and preventative maintenance tasks like backup and recovery.
Rate it! Rate my session and offer feedback here.