I am very excited to announce that we are sold out for the two of our class focusing on the USA time zone for Practical Real World Performance Tuning. This is indeed very exciting. If you have signed up for the training, we will be meeting later this week and next week. If you have not signed up for the training, indeed we will miss you during our training.
To be super honest, the request for this training was in demand for a quite a while and at the price point of USD 495, it was a quite a deal. Honestly, I had never thought that this training will be sold out so quickly. When I am looking back at this, I feel pretty comfortable that both the classes are filled up 100% and the audience is going to have lots of fun.
About the Workshop
In the real world when we face any performance problems, we do not have the luxury to open PowerPoint and study theory. What helps us during the time of crisis are handy scripts which help us fix our performance problems. In this quick paced, demonstration oriented learning workshop, we will see how we can immediately help our application with performance if we just know what exactly to do. Following the practices in this 4-hour workshop can help mitigate your current performance problems but also helps you to put your preventive action plans.
Remember the workshops are recorded and you can watch them for free for one year from the date you take your workshop.
You Missed It – Alternatives
If you have missed to sign up for the training, there are few alternatives.
Option 1: Class London Audience
We recently opened a new class which is for London time zone. As this class is just opened there are few seats are still available for the class offered for London. You can still sign up for them here: . However, please note that these seats will not last long as well.
Option 2: Private Class for Your Organization
I can offer a customized private class for your organizations. You can read about the class here SQL Server Performance Tuning Practical Workshop. You can maximum have 8 attendees in this class and it costs USD 1600 if you sign up before June 30th (once signed up you will have 60 days to schedule the class at a mutually convenient time). The price of the class goes up to USD 2000 from July 1st, 2018.
Option 3: Free Video Learning
You can watch the sample of this class for free over here. Yes, it is absolutely true. No cost to you at all. Free learning.
Option 4: Wait for the year 2019
Well, we may plan few more classes in 2019. You can for sure wait till next year. However, if I were you, I will take sign for either option 1 or option 2 and anyway take advantage of option 3.
Modules and Agenda
Module 1: Indexing, Worst Practices, and Solutions (60 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 which last longer. We will also build a preventive auto-healing system which can help you focus on more complicated performance issues.
We will cover following essential aspects:
- Unused Indexes (demo)
- Missing Indexes (demo)
- Duplicate Indexes (demo)
- Importance of Clustered Indexes (demo)
- Scripts to see Number of Indexes on Table (demo)
- Columnstore Index with In-Memory Table (demo)
Bio break – 15 minutes
Module 2: Optimal Server and Database Settings for Efficiency (60 minutes)
Any good singer needs the support of the 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 set optimal configurations for SQL Server Instance and Database. We will also understand methods to maintain our indexes at the optimal health all the time.
In this module of the workshop, we will cover server and database settings which directly affect the performance of indexes and overall system health.
We will cover following essential aspects:
- Min and Max Memory (no demo)
- Index Creation Memory (no demo)
- Default Index Fill Factor (no demo)
- Compatibility Level (demo)
- Auto-Create and Auto Update Statistics (demo)
- Index Maintenance (Ola’s script) (demo)
Bio break – 15 minutes
Module 3: WhichIndex – An Interactive Game with WHERE clause and Multi-Column Indexes (60 minutes)
WhichIndex is the 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 concept, 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.
Email break – 5 minutes
Module 4: Mythbusters, Questions, and Answers (15 minutes)
In this final part of the module, we will open the floor for questions and answers. We will start our module answer following three critical issues and will continue to answer user questions like:
- Do we have to update statistics after rebuilding indexes?
- What should we do if our index rebuilding is taking forever and creates performance issues?
- When to use INCLUDE column and what columns we should include in that clause?
Reference: Pinal Dave (https://blog.sqlauthority.com)
