Performance Tuning & Optimizing SQL Databases is a four-day training course that has been designed for individuals who manage and maintain SQL Server databases to equip them with the skills to performance tune and optimize their databases.
Completion of the course equips the participants with the following concepts and skills:
Module 1: SQL Server Architecture, Scheduling, and Waits
Module 2: SQL Server I/O
Module 3: Database Structures
Module 4: SQL Server Memory
Module 5: SQL Server Concurrency
Module 6: Statistics and Index Internals
Module 7: Query Execution and Query Plan Analysis
Module 8: Plan Caching and Recompilation
Module 9: Extended Events
Module 10: Monitoring, Tracing, and Baselining
In addition to the professional experience, candidates who attend this training must possess the following technical knowledge:
Name | Code | Fee |
---|
OR