SQL Server Performance Tuning Practical Workshop – Live Classes
SQL Server Performance Tuning Practical Workshop is my the MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
|Live Online Classes||Recorded Online Classes|
Please send an email to pinal@SQLAuthority.com if you have any questions.
What Makes this Training Workshop Unique?
I offer a very popular Comprehensive Database Performance Health Check service. While I help organizations to improve their performance, I personally gain knowledge as well. I have pretty much seen every possible error while working with SQL Server. I have seen DBAs configuring their system in such a way that they will instantly kill the server’s performance. I have also come across SQL Developers who write scripts that can shut an entire system down in just a few seconds.
I personally do not like to call it training, I think training is not the right word for what we do. I think it is more like Sharing Business Secrets. In this experience, I will explain and share all the tricks, scripts, and secrets that I practice for my customers in my business.
This workshop is crafted from my many years of experience working with over 400 customers to help them build a robust system that runs extremely fast.
What is Covered in this Training?
This is extremely sharp, fast-paced 3–4 hours of training, where we learn various real-world performance troubleshooting scenarios and their resolutions.
The training is divided into three major parts.
Module 1: Indexing, Worst Practices, and Solutions (70 minutes)
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.
Comfort break – 15 minutes
Module 2: WhichIndex – An Interactive Game with WHERE clause and Multi-Column Indexes (70 minutes)
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.
Comfort break – 15 minutes
Module 3: Don’t Change Code – An Interactive Game with Functions, Views, and Indexes (50 minutes)
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 is 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.
Comfort break – 15 minutes
Module 4: Your Server, Your Questions
In the final part, we usually discuss the performance problems you are facing with your server. If you do not have additional questions, we usually spend the rest of the time looking at various real-world scenarios related to SQL Server Query Execution Plans and Performance. We often spend time discussing the following in this module.
- Server Configurations for Performance
- Instance Configuration for Performance
- SQL Server DBCC Best Practices
- Log Reviews (Windows Event Logs, SQL Server Error Logs and Agent Logs)
- Hardware Discussions
- Index Analysis and Optimization
- I/O Distribution Analysis
- Effective Query Writing
- SQL Server Resource Wait Stats Analysis
- SQL Server Best Practices
We will learn together, how to solve real-world performance problems systematically and scientifically.
Note: Module 4 is converted to 1-hour free consulting engagement for recorded classes.
Is This training Online or Offline?
The training is online via GoToMeeting.
The training is delivered via GoToMeeting. I will share my screen and walk you through various examples. We can share screens during the training if needed. The only prerequisite is to have a good Internet connection and you can take part from anywhere in the world.
How Long is the Training?
Maximum of 4 Hours.
This is an extremely practical workshop where learners are taught and can put what they have learned immediately to work and get maximum return on their investment.
This training is not regular theory training over several days, where the user learns for many days and but hardly uses the skills in real life. Additionally, lots of organizations are not able to spare their DBA for 4 or 5 days of training, so it takes up their vacation time. This workshop involves extremely sharp, fast-paced 3–4 hours of training, where we learn various real-world performance troubleshooting scenarios and their resolutions.
Trust me – you want to learn the performance tuning secrets in the shortest period of the time, so you can spend time on things that are more important to you.
Does the User Get ALL the Scripts Used During the workshop?
You will receive every single script that you learn during the workshop.
Along with the scripts during the workshop, I will also share some very powerful and useful resources.
At the end of the workshop, you won’t just have the scripts you will also receive many other important resources related to SQL Server Performance Tuning.
Will There be Attendees from Other Organizations?
No, the workshop is exclusively for you and your company.
It is not generic training, it’s personalized for you and your organization. In the training, it will be the members of your organization only.
This way we can focus on your learning which matters to you and your organization the most. There are two advantages of doing training exclusively for your organization.
- You can share any details related to your organization without worrying about business secrets and privacy.
- You do not have to hear questions and concerns that are not directly relevant to your organization.
Experience has taught me that the ideal number for this training is 4 people.
Try Before You Buy
Of course! You should try the sample training before you go for the whole nine yards.
One thing I promise is that I will make this often-boring subject fun! This learning experience is so immersive that you will not realize how fast the time has passed.
Click here to watch my free training videos.
You can also subscribe to my YouTube Channel for SQL in Sixty Seconds Learning.
What is the cost involved?
USD 4000 USD 3000 (25% discount till the end of this month).
The price is a fixed-rate price for the entire workshop. Please note that this is for the entire workshop and not priced for individuals. You can have up to 4 people in one seminar and the price will remain the same.
How to get Started?
We can get started in just 3 steps.
Step 1: Send me an email at firstname.lastname@example.org with the following information:
- A brief about you
- The name of your company
- Your location (so that I know what time zone you are in)
Step 2: I will reply with the following information:
- Earliest available calendar slot
- Payment link (Credit Card, Debit Card, Bank Transfer and PayPal).
Once we agree on a meeting time and payment is received, we move on to Step 3.
Step 3: I will send you a GotoMeeting invite, which you can share with your team.
That’s it, we are ready to meet!