1 - SQL Server Architecture, Scheduling, & Waits
SQL Server Components and SQL OSWindows Scheduling vs SQL SchedulingWaits and QueuesLab: SQL Server Architecture, Scheduling, and Waits
2 - SQL Server I/O
Core ConceptsStorage SolutionsI/O Setup and TestingLab: Testing Storage Performance
3 - Database Structures
Database Structure InternalsData File InternalsTempDB InternalsLab: Database Structures
4 - SQL Server Memory
Windows MemorySQL Server MemoryIn-Memory OLTPLab: SQL Server Memory
5 - Concurrency & Transactions
Concurrency and TransactionsLocking InternalsLab: Concurrency and Transactions
6 - Statistics & Index Internals
Statistics Internals and Cardinality EstimationIndex InternalsColumn Store IndexesLab: Statistics and index Internals
7 - Query Execution & Query Plan Analysis
Query execution and optimizer internalsAnalyzing query plansLab: Query execution and query plan analysis
8 - Plan Caching & Recompilation
Plan cache internalsTroubleshooting plan cache issuesQuery storeLab: Plan caching and recompilation
9 - Extended Events
Extended events core conceptsImplementing extended eventsLab: Extended events
10 - Monitoring, Tracing, & Baselining
Monitoring and tracingBaselining and benchmarkingLab: Monitoring, Tracing and Baselining
11 - Troubleshooting Common Performance Issues
Troubleshoot CPU performanceTroubleshoot memory performanceTroubleshoot I/O performanceTroubleshoot Concurrency performanceTroubleshoot TempDB performanceLab: Troubleshooting common performance issues
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
The primary audience for this course is individuals 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. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
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.