MS-10987 - Performance Tuning and Optimizing SQL Databases

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Click here to print this page »


In addition to their professional experience, students who attend this training should already have the following technical knowledge:
· Basic knowledge of the Microsoft Windows operating system and its core functionality.
· Working knowledge of database administration and maintenance
· Working knowledge of Transact-SQL.

Detailed Class Syllabus

Module 1: SQL Server Architecture, Scheduling, and Waits

SQL Server Components and SQL OS
Windows Scheduling vs SQL Scheduling
Waits and Queues

Module 2: SQL Server I/O

Core Concepts
Storage Solutions
I/O Setup and Testing

Module 3: Database Structures

Database Structure Internals
Data File Internals
TempDB Internals

Module 4: SQL Server Memory

Windows Memory
SQL Server Memory
In-Memory OLTP

Module 5: SQL Server Concurrency

Concurrency and Transactions
Locking Internals

Module 6: Statistics and Index Internals

Statistics Internals and Cardinality Estimation
Index Internals
Columnstore Indexes

Module 7: Query Execution and Query Plan Analysis

Query execution and optimizer internals
Query execution plans
Analyzing query execution plans

Module 8: Plan Caching and Recompilation

Plan cache internals
Troubleshooting plan cache issues
Query store

Module 9: Extended Events

Extended events core concepts
Working with extended events

Module 10: Monitoring, Tracing, and Baselining

Monitoring and tracing
Baselining and benchmarking