Advanced SQL Server Performance Tuning

A Pragmatic Real World Approach To Tuning SQL Server.
Advanced SQL Server Performance Tuning
File Size :
1.60 GB
Total length :
1h 32m



Mike West


Last update




Advanced SQL Server Performance Tuning

What you’ll 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.

Advanced SQL Server Performance Tuning


You will need to have SQL Server 2012 or 2014 installed. It can be an express version.
I’ll be providing all the scripts and schema for the course. There is no other cost other than the price of the course. Everything else is included or free.
If you’re not familiar with SQL Server fundamentals then this course may not be for you. I do appreciate and understand your enthusiasm and promise this course will be here when you’re ready.


COURSE REVIEWS: “It’s not what I thought it would be. It covers limited topics and does not present a solid step by step approach to approaching a SQL server you’ve never had a dealing with and finding the performance issues and fixing them.” — Albert “This is the 9th Mike West course I have taken. The dude really know his stuff and is able to relay to the listener in a very approachable way. Quick note if you do the exercises yourself – you want to give SQL Server time to “catch up” — Apkambledev”Good & very well explain especially the Live Demo step by step. The way explanation capture the attention to listen & very interesting.” –Micheale.See”Great ,Learning many things. thanks !!”– Mittal “Awesome tutorial.” — Sivram “This is a great quick course with many take aways! It’s short and to-the-point, which’s great for people with familiarity with the subject.” – Said “Excellent course, very good examples” — Cesar “The course is pretty clear so far albeit, slightly brief.” — Ken”Its excellent very much informative.” — Afroz “A good course with information and tips that apply to the real world.” –Ian B”In depth.” — Sherrie “Thanks for the great course!” — Andrey “Nice course. Simple and crisp.” — M1981 “Great course! The things that Mike taught are practical and can be applied in the real world immediately.” — Ricky V. “This gives a deep diving scenario.” — Anish COURSE INTRODUCTIONThis 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.


Section 1: Introduction

Lecture 1 What’s In This Course?

Lecture 2 Content Warning. Please Don’t Skip. Thanks.

Lecture 3 Instructor Introduction.

Lecture 4 Section 1 Summary

Section 2: Tools. These Two Tools Really Help Us Get A Deeper Grain To Our Tuning

Lecture 5 SET Statistics IO and SET Statistics Time On. What Do They Mean?

Lecture 6 Query Plans With Plan Explorer. The Second Best Free Tool On The Market.

Lecture 7 Adding AdventureWorks. It’s Free and Easy. We Will Use It In Our Demos.

Lecture 8 Download Content Here

Lecture 9 Summary 2 Summary

Section 3: Caching Issues

Lecture 10 What is the Buffer Pool?

Lecture 11 High Level Structure of Procedure Cache

Lecture 12 Procedure Cache Architecture

Lecture 13 Simple Parameterization

Lecture 14 Parameter Sniffing Demonstration

Lecture 15 Fixing Parameter Sniffing

Lecture 16 What Are Plan Guides?

Lecture 17 Plan Guides: Demonstration

Lecture 18 Section 3 Summary

Section 4: Hints and Filters

Lecture 19 Using Index Hints For Comparing Index Effectiveness

Lecture 20 Filtered Indexes

Lecture 21 Filtered Indexes With Sparse Columns

Lecture 22 Filtered Index With Massive Reduction In Logical Reads

Lecture 23 Section 4 Summary

Section 5: Trace Flags. If You Feel Safe Using Them – And I Do, Then Start Here.

Lecture 24 Trace Flag: -T4199

Lecture 25 Trace Flag: -T1117

Lecture 26 Trace Flag: -T3226

Lecture 27 Section 5 Summary

Section 6: Real World Coding Best Practices Put To The Test

Lecture 28 Does Using Fewer Columns Really Matter?

Lecture 29 Schema Qualified Objects

Lecture 30 Does SET NOCOUNT ON Really Help?

Lecture 31 Batching Up Deletes And Updates Is A Must

Lecture 32 Stop Sorting In The Database – It’s Killing Your Queries

Lecture 33 Fixing Implicit Conversions

Lecture 34 Taking The Load Off The Overburdened tempdb Database

Lecture 35 Section 6 Summary

Section 7: Miscellaneous

Lecture 36 Enable Auto Update Stats Async

Lecture 37 Section 7 Summary

Section 8: Conclusion

Lecture 38 Thank you! Let’s Wrap Up This Course.

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.

Course Information:

Udemy | English | 1h 32m | 1.60 GB
Created by: Mike West

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top