SQL Server Crashes and Critical Failures

A Step By Step Approach To Recovering The Most Critical SQL Server Databases
Free tutorial
Rating: 4.0 out of 5 (538 ratings)
18,903 students
SQL Server Crashes and Critical Failures
Free tutorial
Rating: 4.0 out of 5 (538 ratings)
18,903 students
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.

Requirements

  • There are no prerequisites for this course but a solid foundation in SQL Server would be helpful.
  • All of the materials will be free or included in the course. There will be no outside purchases necessary to take this course.
  • Any recent version of SQL Server will do but I'd recommend SQL Server 2014.
Description

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.

Who this course is for:
  • SQL Server DBAs wanting to expand their knowledge of how and why SQL Server crahses
  • This is not an entry level SQL Server course. I would not recommend this course for beginners.
  • SQL Server DBAs looking to understand exception signatures and other vernacular associated with critical failures in SQL Server
Course content
5 sections • 25 lectures • 1h 5m total length
  • Course Introduction
    01:26
  • Instructor Introduction
    00:47
  • Download Course Content Here
    00:01
  • Tools We Need For The Course
    03:30
  • The Three Categories of Critical Failures
    01:27
  • Summary
    00:31
  • The Startup Parameters SQL Server Needs
    04:09
  • Starting A Named Instance and Putting That Instance in Single User Mode
    03:53
  • Troubleshooting The Failed Startup With Account Locked Out
    05:51
  • Troubleshooting Failed Startup When Port Already In Use
    03:22
  • Section 2 Summary
    00:41
  • Section 2 Quiz
    15 questions
  • Starting With A Clean Error Log
    01:37
  • What's in The ErrorLog - Part 1
    01:46
  • What's In The ErrorLog - Part 2
    03:42
  • What's In The ErrorLog - Part 3
    02:59
  • What's In The ErrorLog - Part 4
    02:09
  • Summary
    00:37
  • Section 3 Quiz.
    10 questions
  • Restoring The Resource DB From Another Instance
    05:59
  • Restoring The Master Database When Instance is Online
    03:36
  • Recover Corrupt Model Database From Another Instance
    04:16
  • Recovering A Lost SA Password
    05:50
  • Repairing Tempdb Corruption
    02:05
  • Rebuilding the Master Database
    03:51
  • Summary
    00:39
  • Quiz
    10 questions
  • Conclusion and Thank You
    00:30

Instructor
Machine Learning Evangelist
Mike West
  • 4.2 Instructor Rating
  • 10,608 Reviews
  • 206,441 Students
  • 49 Courses

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman. 

Over the last five years I've transitioned to the exciting world of applied machine learning.  I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.

Experience, education and passion 

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car. 

Certifications  

Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT). 

Personal  

Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.