Advanced SQL Server Performance Tuning (Udemy.com)

A Pragmatic Real World Approach To Tuning SQL Server.

( 47 Reviews )

Created by: Mike West

Produced in 2015

What you will learn

By the end of this course you will have a systematic process approach and all the necessary tools needed to begin your journey as a SQL Server performance tuner.
In this course we will dive a little into performance tuning. We will look caching, hints, filters, trace flags and best coding practices.
In the course we will use statistics and query plans to analyze the effectiveness of our indexes.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 78 / 100

Course Description

Please note: This is a continuation from my first course titled, "How to Become a World Class SQL Server Performance Tuner." I highly recommend you take that course first.
"I've been working as SQLServer dba for +8 years, but I'm still learning every single day... So, thanks a lot for your courses, videos and tutorials, they really help me."
Fer
"He uses clear cut examples to illustrate real world scenarios. Mike is one of the few SQL Server instructors that seems very focused on performance issues and I'm really glad to have stumbled onto his courses."
Ken
This course focuses on making SQL Server perform more optimally.
In my first course we laid the groundwork by tuning OUR instances with a top down approach.
WE will continue on that path with this course.
Even though the course has the word "Advanced" in it, there's NOTHING COMPLICATED about taking what's in the course and applying it in the real word.
It's "advanced" in that I'll take more time explaining how to implement these recommendations.
The course is still very much a "buttons and Knobs" course. This simply means WE won't dive too deeply into the minutia. We are still going to focus on items that are easily implemented. Some features will have a level of contention associated with them in the SQL Server community. It will be up to you decide to implement or not.
Additionally, some of the concepts may be new to even more senior level resources so I want to make sure I'll cover the why of the topic as well as the how.
This course will give YOU deeper insight into what it takes to become a skilled PERFORMANCE TUNER.
Once thought of as an art, performance tuning is nothing more than a series of processes that seek to accomplish TWO basic goals.
The FIRST one is to increase the response time for a given transaction or set of transactions.
The SECOND one is reduce resource consumption. On the surface this sounds simple but nothing could be further from the truth.
Take the next step on YOUR performance tuning journey and SIGN UP now. Who this course is for:

If you have basic understanding of SQL Server and want to learn how to tune and optimize a SQL Server then this course is for you.
This course is not a beginner's course. Most of the students will be mid-level to senior SQL Server resources.
You'll need to be familiar with transact SQL and have a strong grasp navigating SQL Server Management Studio.
My first is not required but it will help build a foundation for some of these more complicated topics.

Time: 1.5h

Instructor Details

Mike West

3.9 Rating
47 Reviews

Machine Learning Enthusiast
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 w