How I Solve 95% of All SQL Server Outages

Learn How To Troubleshot Any Down SQL Server With One Free Script

4.30 (328 reviews)
Udemy
platform
English
language
Other
category
instructor
2,095
students
1.5 hours
content
Sep 2015
last update
$54.99
regular price

What you will learn

Be able to troubleshoot the vast majority of produciton down situations.

Understand how organic transactions flow through a well tuned SQL Server.

You'll have a well defined, simplistic process approach on how to approach any outage.

Answer any interview question on the topic of production outages with conviction.

Speak the proper vernacular when discussing performance tuning, wait statistics and SQL Server incidents.

Accurately analyze performance related outages.

Description

COURSE REVIEWS: 

"This was one of the most useful classes I have taken in a long time. Very specific, real-world examples. It covered several instances of 'what is happening', 'what it means' and 'how you fix it'. I was impressed."  Steve

"Mike West ROCKS and is a FANTASTIC TEACHER for newbie DBAs! If you offer more videos on the subject i will be one of the first to sign up!!" - Rob R

"I've been a DBA for a few years now and have used sp_who is active for years (and love it!) and even I learned a few new tricks. Great class!" Nancy

"Well the credit also goes back to the mentor of this online course... yes it is worth for small amount of price." HCDS Academy

"Very practical course" - Guillermo

"I love the detail and the real world applications" - Darryl

"Knowledge is always about applied information towards getting results in a particular context. This is pristine knowledge supported by the experience of Mike. Solid gold" - Roman

"Awesome course, it showed me some useful tips and some neat things which I will be using from now on" Thomas

"Does an excellent job of (a) explaining course intent, (b) concepts, and most importantly, (c) explains the tools, gives a detailed (and easy) description of how to install them, and how to use them, and for what purpose. Great course!" Douglas T.

"This will give you a head start when it comes to trouble shooting your SQL server. Thanks Mike !" Luke D

"Instructor was engaging and the course material was just the right about to get to the core of the issues." Texas Squirrel

"Difficult concepts expressed in simple terms." Dare David

COURSE DESCTIPTION

What do I mean when I use the words “real world?"

This course is about learning a very specific skill that's one of the most important ones to becoming a senior level SQL Server DBA and that is - Where do you begin troubleshooting production issues?

I'm going to give you the starting point and we are going to work through several examples of real world scenarios where a SQL Server was down  and how I brought back online.  You'll learn the language of performance tuning. 

All industries have their own vernacular and the SQL world is no exception.I'll be introducing some new terms and scripts that are very specific to performance tuning and optimization. 

These scripts and how I apply them are worth the cost of the course.  Performance tuners are like mechanics. Our goal is to keep the SQL engine as tuned as it possibly can be. 

One stored procedure to rule them all!  

In the real world, the elite SQL Server DBAs don't use canned tools. Many of the greats have a library of scripts and they use ONE of these every single day. 

If you don't have a script library started then I'll show you how to set one up and GIVE you your first few scripts. 

When I'm called into troubleshoot a struggling SQL Server I always use ONE script first. 

This script was developed by one of the world's leading experts on SQL Server and used by many of the world's leading experts on SQL Server. 

This is a hands on course

You will simulate a OLTP application and learn what to look for when issues arise. All of the demos are written in transact.  Everything is included in the price of the course. Set up for the course is easy. Installing the tools will take several minutes. 

The most important part of our course will be working through the real world examples. All my lessons will have very specific instructions. The set up for all of the lessons is simply to cut and paste the transact code into SQL Server Management Studio.   

The vast majority of the course will be working through the demos and analyzing how to troubleshot production down issues and what steps can be taken to bring the server back online. 

The course will also include lectures but the lectures will be short and pragmatic. SQL Server is one of the most complicated pieces of software in Microsoft's suite. This course will provide you with the single most important facet to analyzing real world outages. Where do you start?   

If you want to be one of the most skilled SQL Server DBAs then you MUST learn how to use this script effectively!  

Start now! Enroll today.  

Content

Preparation

After 15 years of experience I've Solved Over 100 outages. Let me show you how.
What Does A SQL Server Database Do? Not what it is but what does it do?
You Can Take this Course Several Ways But I'd Suggest You Start at the Beginning
This Quick Quiz Will Help You Cement What We've Covered So Far.

Installation

This Approach Works and Here's the Simple Reason Why.
We Only Have One or Two Tools to Install. They will help us immensely.
Setting Up Our OLTP Load Generator To Simulate a Real SQL Server
We Must Learn The Basics of Wait Statistics Before We Can Master Tuning.
One of The World's Greatest SQL Server Machanics Created This Free Tool.
The One Minute Process Flow and how we can easily apply it to our approach.
Installing the Tools

Lessons From the Field

How SQL Can Thrash a SAN and How We Can Easily Fix it.
Restricting File Growth is a bad Idea so We Should Fix it Right Now.
Without The Right Amount of Memory We Can Pressure the SAN.
Deleting in an OLTP Application is Problematic. If You Must, Delete This Way.
Resolving Tempdb Latch Contention is Very Easy. Add this Easy Button Fix Now.
Using Showplan Analysis in Conjunction With Our Approach
The Explicit Ad Hoc Blocker and Why All AdHoc isn't Great for OLTP Boxes.
Learn How To Correctly Answer Interview Questions on Fixing SQL Outages.
What's in Your Script library and Why You Need One of It's empty.
Lesson From the Field

Final Thoughts

Thank You For Taking This Course and a Few Additional Learning Resources.
Wrapping Up What's We've Learned and Where to Go Next.
I Really Want Your Feedback. Help Me Get Better and I'll Repay That Generosity.

Screenshots

How I Solve 95% of All SQL Server Outages - Screenshot_01How I Solve 95% of All SQL Server Outages - Screenshot_02How I Solve 95% of All SQL Server Outages - Screenshot_03How I Solve 95% of All SQL Server Outages - Screenshot_04

Reviews

Heath
September 15, 2021
Great job! Was a little fast at the beginning, but once I got into the flow (short time), had no problems at all! All the material provided and easy to follow!
Thomas
May 20, 2016
Awesome course, it showed me some useful tips and some neat things which I will be using from now on. I found the course very helpful and very useful, not only for the big issues but it is also filled with helpful tips like DELETE TOP, I had never thought of doing deletes this way before.
Greg
April 12, 2016
Overall a very good course. My only issues were in the first section where Mike runs through some examples but doesn't explain them very well or refers to a previous course without naming it explicitly. Also, a couple of the quiz questions were not on the info covered.
Miles
April 12, 2016
No waffle. No low-grade filler material. Just useful targeted performance tuning information. Would recommend this course, especially as a foundation for deeper research. For the price, it's excellent value.
Douglas
March 23, 2016
Does an excellent job of (a) explaining course intent, (b) concepts, and most importantly, (c) explains the tools, gives a detailed (and easy) description of how to install them, and how to use them, and for what purpose. Great course!
Rob
February 21, 2016
Mike West ROCKS and is a FANTASTIC TEACHER for newbie DBAs! If you offer more videos on the subject i will be one of the first to sign up!!
Texas
January 2, 2016
Instructor was engaging and the course material was just the right about to get to the core of the issues.
Kevin
October 28, 2015
Similar to world class perf tuning, but different enough to be worth the fee. Reinforcement is good :)
Andy
October 19, 2015
Very enjoyable course, I'm meant to be a Senior DBA and I learnt a lot here. It does cover a lot of topics quite briefly but I quite liked that as it gave me a good starting point for stuff I'd like to study more. It could probably do with a overview of what's going to be covered section as it does jump from topic to topic quite a lot. But to be fair it's meant to be about the sort of different things you'll see in the field. In summary though, there's some absolute gold to be found here and I'd defy any DBA not to learn something from this. It serves as a good tutorial to sp_whoisactive as well which is something all SQL Server Professionals should not be without.
David
August 21, 2015
This was a great course where the instruction was understandable and fun to follow. I would highly recommend everyone to take this course.
Stephen
August 9, 2015
Great content, had trouble printing the certificate at the end but I'm assuming that was an issue with the website not the instructor. His material is well organized and provided an overall strategy that can be used when both first learning to troubleshoot outages and as an overall methodology.
Praveen
June 22, 2015
If you're looking to hone performance tuning skills in SQL Server - this video will guide you through important step. My only suggestion - wished he had more descriptive contents and video lectures were longer. Other than that, it was pleasure learning with Mike!
Jim
May 21, 2015
This course gives a real world look into putting various SQL scripts to work right away (scripts/tools included). Several common scenarios are described, and solutions presented. Well worth a look. Thanks!
Ken
May 9, 2015
I cannot over emphasize how much I appreciate this course. I really enjoy SQL development and have taken several courses on SQL Server development and administration but this is the first course I've found that gives real world examples and exercises for performance trouble shooting. The course introduced me to the SQL Load Generator and it's used very effectively to execute very simple scripts and provides live activity that you monitor as it runs. Mike does a great job delivering the content and I can't wait to dive into some of his other courses. Mike, thanks VERY much for this course. I'm looking forward to getting into your performance tuning course.
Laurence
April 14, 2015
This is a fantastically structured course, and the material alone is worth more than the course itself. Excellent material, well structured approach. Fantastic Course!! A+++

Charts

Price

How I Solve 95% of All SQL Server Outages - Price chart

Rating

How I Solve 95% of All SQL Server Outages - Ratings chart

Enrollment distribution

How I Solve 95% of All SQL Server Outages - Distribution chart

Related Topics

419360
udemy ID
2/11/2015
course created date
11/20/2019
course indexed date
Bot
course submited by