Optimizing the performance of your SQL Server has always been important, but now this task becomes even more important. In times of cloud database services, with a well-functioning SQL Server you can save a lot of money by down-scaling your database or simply get more performance for your money.
In this practical one-day workshop you will learn how to optimally set up, configure and monitor your SQL Server to get the most out of your database.

In detail we will cover the following topics:

• Concept of the non-preemptive SQLOS
• Setting of Maximum Degree of Parallelism and Cost Threshold for Parallelism
• Analyse and resolve waits like latches and blocks
• PFS, SGAM, GAM, Extent Management
• Add the best number of files in user database and tempdb
• Interpret the Query Plan
• Understand the most common iterators and their memory, CPU and IO impact
• Use Query Store to find most expensive queries and detect plan regression
• Index tuning