Optimizing SQL Server performance: advanced Training - Course

Objectives

To provide the knowledge and skills required to optimize MS SQL Server 2012 / 2014 / 2016 databases when you queries cannot be modified.

Database developers and administrators.

Experience in MS SQL Server administration (course MS509) ou (course MS512).

How statistics can affect query performance
Reading statistics
The mathematics behind statistics
Understanding how to evaluate your SQL server: metrics to use
Understanding the different Waits: ASYNC_NETWORK_IO, CXPACKET, PAGEIOLATCH ,SOS_SCHEDULER_YIELD and WRITELOG
Reading execution plans
Using Plan Cache for finding problematic queries
Analyzing slow queries: missing indexes, implicit conversions, parameter sniffing, predicate issues
How SQL Server uses indexes
Clustered and Nonclustered indexes
When to use inclusive indexes, filtered indexes or calculated indexes to accelerate queries
Optimizing indexes using Plan Cache
Proving that indexes have improved performance
The challenge of missing indexes
Partitioning
Columnstore indexes