SQL Server Performance Tuning Practical Workshop – Recorded Classes

SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Please send an email to pinal@SQLAuthority.com if you have any questions.

This class is built on my most popular content which I have been delivering for many years. I offer a very limited training class every year. However, there is a huge demand for this workshop as it contains around 3 hours and 49 minutes of unique content which is considered as absolutely Trade Secret for SQL Server Performance Tuning Consultant.

On the popular demand of everyone, I am going to make this class available for everyone for Instant Learning. Here is the video recording of the class, at your own comfort you can now watch it from office, home, or on mobile during your daily commute.

The following video is password protected. Just enter the valid password and you will it will instantly play the video. If you do not have a password, you can purchase the video for 30 days of unlimited views. Once the payment is completed, you will receive the password in 8 hours (most of the time in less than an hour) at your registered email address. Along with the password to watch a video, you will also receive All the Performance Tuning Scripts discussed in the class. Additionally, you will get free access to the Slack support group where you can ask questions related to the workshop as well as network with fellow graduates from the workshop.

Every license of the video viewing is valid for one month. However, every additional seat you purchase for your colleague, the validity of the license is increased by one additional month. If you have made the payment and do not have access to the above video, please reach out to me with the payment details at pinal@SQLAuthority.com and I will be happy to assist you.

This is extremely sharp, fast-paced 3–4 hours of training, where we learn various real-world performance troubleshooting scenarios and their resolutions. 

Agenda

The training is divided into three major parts.

Module 1: Indexing, Worst Practices, and Solutions 

Indexes are often considered a silver bullet to solve performance problems, but the reality is far from the age-old myth. The right index can help improve performance, but the wrong indexes often play party spoiler and reduce your server’s performance. Identifying which indexes to create and which indexes to delete can be cumbersome (or near impossible) if we do not know how to do workload analysis.

In this module of the workshop, we will see some neat tricks related to how to create useful indexes that last longer. We will also build a preventive auto-healing system that can help you focus on more complicated performance issues.

Module 2: WhichIndex – An Interactive Game with WHERE clause and Multi-Column Indexes 

WhichIndex is an interactive game that gives a new experience to teach you how to understand how multi-column indexes work with queries with multiple conditions.

This game follows the format of open-book exams where every user begins with answers to the questions. Once we understand our solutions, we start our journey to this interactive game. At a different interval of this game, users have to answer the question WhichIndex to the quiz master.

In this self-scored game, the winner is the person who gets the maximum answers wrong. If you have not understood the basics of indexes and performance tuning concepts, you will solidify that concept while we play this game.

On a side note – cheating is not only allowed but is heavily encouraged as well!

At the end of this game, users will have an understanding of three essential rules related to Indexes, which YOU will never forget.

Module 3: Don’t Change Code – An Interactive Game with Functions, Views, and Indexes 

Any good singer needs the support of a decent sound system and cooperative band to be successful. Similarly for any index to be successful, it requires a supportive environment. It is incredibly critical to learn how indexes selection takes shape when functions are used in the query.

We start with a problem where there are a query and an index. The query is not using the index. The challenge which we have to solve in this game is to make the necessary modification, so our query uses our index. However, there is one condition – Don’t Change Code. We are not allowed to change the query.

While I struggle to solve this puzzle, your responsibility will be to help me out with various ideas and also help me honor the one condition of the game – Don’t Change Code.

The game is indeed a very fast-paced but at every twist and turns we will take a few moments to understand the secrets of indexes.