SQL Server Performance Tuning Practical Workshop
SQL Server Performance Tuning Practical Workshop is my the MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
What makes this training workshop unique?
I offer very popular Comprehensive Database Performance Health Check service. While, I do help organizations to improve their performance, I personally gain a plethora of knowledge. I have pretty much seen every possible errors human do while working with SQL Server. I have seen DBAs configuring their system such a way that they it will instantly kill server’s performance. I have also come across SQL Developers who write queries which are capable to get entire system down in just few seconds.
I, personally, do not like to call it training, I think training is not a good word for what we do. I think it is more like Business Secrets Sharing. In this experience, I explain and share all the tricks, scripts and secrets which I practice at my customer place and generate business for me.
Well, this training workshop is crafted from my many years of experience of working with over 400 customers to help them build a robust system which runs extremely fast.
What is covered in this training?
This is extremely sharp, fast paced 3-4 hours training, where we learn various real world performance troubleshooting scenarios and their resolutions.
The training is divided into three major parts
Part 1: Server and Instance Troubleshooting and Best Practices
In this first part we discuss following important elements with practical examples
- 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
Part 2: Query Performance Troubleshooting and Best Practices
- Index Analysis and Optimization
- I/O Distribution Analysis
- Effective Query Writing
- SQL Server Resource Wait Stats Analysis
- SQL Server Best Practices
Part 3: Your Server, Your Questions
In this part, we usually discuss about Performance Problems, you are facing with your server. If you do not have additional questions, we usually spend the rest of the time to see various real world scenarios related to SQL Server Query Execution Plans and Performance.
We will learn together, how to solve real world performance problems systematically and scientifically.
Is this training Online or Offline?
Online Training via GoToMeeting.
The training is delivered via GoToMeeting. I will be sharing my screen and walking you through various examples. It allows us to share our screen if needed during the training. The only prerequisites is to have a good internet connection and you can be part of this scenario from anywhere in the world.
How long is the training?
This is an extremely practical workshop where learnings users are exposed can put immediately into work and get maximum return on investment from it.
This training is not regular multi day theory training, where user learn for many days and hardly utilize them in real life. Additionally, lots of organizations are not able to spare their DBA for 4 to 5 days training, which essentially turns to their vacation. This is extremely sharp, fast paced 3-4 hours training, where we learn various real world performance troubleshooting scenarios and their resolutions.
Trust me – you want me to learn the performance tuning secrets in the shortest period of the time, so you can do other things, which are more important to you.
Does the user get ALL the scripts used during the workshop?
You will receive every single script which we will learn during the workshop.
Along with the scripts during the workshop, I will also share some very powerful and impactful resources.
At the end of the workshop, not only scripts, but you will receive many other important resources related to SQL Server Performance tuning.
Is it like webinar where there will be attendees from other organizations?
No. It is exclusively for you and your organization.
This is personalized training for you and your organization. It is not a generic training. You will have all the members in the training from 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 the questions and concerns which are not directly relevant to your organization.
My earlier experience says that the ideal number of the individuals is 8 for this training.
Try before you buy
Of course! You should try out sample training before you go for the whole nine yards.
One thing I promise you that subject like database which is very boring, I make it fun! This fun & learn, experience is so immersing that you will not realize how fast the time will pass.
Click here to watch my webinar 3 Common Mistakes to Kill SQL Server Performance.
You can also subscribe to my YouTube Channel for SQL in Sixty Seconds Learning.
What is the cost involved?
USD 2200 USD 1600 (for July/August month).
Yes, the price is fixed rate price for the entire workshop. Please note that fees is fixed for the workshop and not priced for individuals. You can have maximum up to 8 people in one seminar and price remains the same.
How to get started?
There are three steps to get started
Step 1: Send me email at email@example.com with following information:
- Brief About You:
- Name of the Company:
- Country Located: (this helps to determine time zone)
Step 2: I will reply with following two information:
- Earliest Available Calendar:
- Payment Link (Credit Card, Debit Card, Bank Transfer and PayPal):
Once we agree on a meeting time and payment is received, we move to Step 3
Step 3: I send you GotoMeeting invite which you can share with your team
That’s it. We are ready to meet.