Course description

Identify and diagnose bottlenecks to improve overall performance of your SQL database.

In this course you will develop the practical tuning and optimization skills that will increase efficiencies in your SQL Server database. You will learn about best practices related to data files for user databases and TempDB, as well as concurrency, transactions, isolation levels, and locking. You will also discover the techniques and develop strategies on how best to analyze collected data.

Each individual Microsoft Official Course On-Demand includes 3 months (or 12 months with purchase of Microsoft Total Access Collection) of 24x7 access to the following:

What You’ll Learn

Who Needs to Attend

IT professionals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.


Course Outline

  1. SQL Server Architecture, Scheduling, and Waits

  1. SQL Server I/O

  1. Database Structures

  1. SQL Server Memory

  1. Concurrency and Transactions

  1. Statistics and Index Internals

  1. Query Execution and Query Plan Analysis

  1. Plan Caching and Recompilation

  1. Extended Events

  1. Monitoring, Tracing, and Baselining

  1. Troubleshooting Common Performance Issues


Lab 1: SQL Server Architecture, Scheduling, and Waits

Lab 2: Testing Storage Performance

Lab 3: Database Structures

Lab 4: SQL Server Memory

Lab 5: Concurrency and Transactions

Lab 6: Statistics and Index Internals

Lab 7: Query Execution and Query Plan Analysis

Lab 8: Plan Caching and Recompilation

Lab 9: Extended Events

Lab 10: Monitoring, Tracing, and Baselining

Lab 11. Troubleshooting Common Performance Issues