What you'll learn:
- You will be comfortable with reading the SQL Server error log in great detail
- By the end of this course you will be able to diagnose and resolve critical SQL Server engine errors.
- You will be able to read the basics of SQL Server stack dumps.
Software crashes. WE can't stop that. What WE can do is prepare ourselves through education and practice to be able to act quickly and resolve these critical issues.
In the early days of SQL Server many support calls were server down issues that ended up being bugs in SQL Server. While this still happens, today many of those calls aren't the fault of SQL Server.
For example. On Microsoft's case history of database corruption 99% of ALL database corruption can be traced back to the IO subsystem.
Either way, when SQL Server crashes it can be a traumatic experience for a DBA. If a production box crashes during core hours WE need to know what steps to take to resolve the problem as quickly and as cleanly as possible.
This course will take US beyond where to look. WE will cover RECOVERY INTERNALS and the fundamentals of how to analyze, diagnose and resolve critical errors.
WE will cover the SQL Server Error Logs in great detail. One of the first places as SQL Server DBAs WE look to diagnose critical failures is the SQL Server Error logs.
WE will cover server startup failures and analyze SQL Server stack dumps. Additionally, we will analyze several commonly occurring exception signatures.
WE will create a troubleshooting task list as use it as a template for resolving these crashes and critical errors.
While this course has no prerequisites a strong background in SQL Server is highly recommended.
