How to Become a World Class SQL Server Performance Tuner

Use These Scripts in Production Right Now

Created by: Mike West
Creator of LogikBot

What Will I 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 define our performance tuning objectives before we dive head first into tuning. What is our end goal? What steps are we going to take to arrive at this goal? Our end goal needs to be realistic and measureable.
• Let’s define them right now. Your goal be the end of the course will be speed up data retrieval on the worst performing queries by at least 30%.
• Secondly, your goal will be to reduce system stress on either the IO subsystem, memory or cpu by 20%.

Requirements

• 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 don't have a performance tuning script library then we will start one. If you do, then we will add to it.
• 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.

Target audience

• 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 junior to mid-level SQL Server resources.
• You'll need to be familiar with transact SQL and have a strong grasp navigating SQL Server Mangement Studio.
• Using the collegiate scale as a guide this course will be a 300 level course. Please keep in mind this is a 101 level course for performance tuning and optimization, which is an advanced topic within the umbrella of the DBA.