10987: Performance Tuning and Optimizing SQL Databases


This 32 hours course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Audience(s):  IT Professionals
Technology: SQL Server
Duration:  32 hours

Module 1: SQL Server Architecture, Scheduling, and Waiting

Module 2: SQL Server I / O

Module 3: Database Structures

Module 4: SQL Server Memory

Module 5: SQL Server Concurrency

Module 6: Statistics and Internal Indexes

Module 7: Executing Queries and Analyzing the Query Plan

Module 8: Planning for Caching and Recompilation

Module 9: Extended Events

Module 10: Monitoring, Tracing and Establishing Bases

Session 1   Session 2
Start Date:  Start Date:
End Date:  End Date:
Day(s):  Day(s):
Hours:  Hours:

More Information