Overview
This 4-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance and optimize their databases.
Prerequisites
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
Who Should Attend?
This course is highly recommended for 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.
This course is also recommended for individuals who develop applications that deliver content from SQL Server databases.
Course Outline
- SQL Server Components and SQL OS
- Windows Scheduling vs SQL Scheduling
- Waits and Queues
Lab: SQL Server Architecture, Scheduling, and Waits
- Core Concepts
- Storage Solutions
- I/O Setup and Testing
Lab: Testing Storage Performance
- Database Structure Internals
- Data File Internals
- TempDB Internals
Lab: Database Structures
- Windows Memory
- SQL Server Memory
- In-Memory OLTP
Lab: SQL Server Memory
- Concurrency and Transactions
- Locking Internals
Lab: SQL Server Concurrency
- Statistics Internals and Cardinality
- Estimation
- Index Internals
- Columnstore Indexes
Lab: Statistics and index Internals
- Query execution and optimizer internals
- Query execution plans
- Analyzing query execution plans
Lab: Query execution and query plans
- Plan cache internals
- Troubleshooting plan cache issues
- Query store
Lab: Plan caching and recompilation
- Extended events core concepts
- Working with extended events
Lab: Extended events
- Monitoring and tracing
- Baselining and benchmarking
Lab: Monitoring, Tracing and Baselining