10987: Performance Tuning and Optimizing SQL Databases

23/4/2024

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