A customized Database Administration Course for Modular Mining
Module 1. SQL Server Performance Monitoring Tools
- Anatomy of a Monitoring Solution
- Dynamic Management Objects (DMV/DMF)
- Extended Events and Tracing
- System and Performance Monitor
- Creating and Analyzing a Baseline
- Query Store in SQL 2016
- Third Party Tools
Module 2. CPU and Scheduling
- Waits and Queues
- Troubleshooting and Tuning
- Resource Governor
Module 3. SQL Server Memory
- Memory Architecture in SQL Server
- Memory Configuration
- Buffer Pool Extension
- Memory Monitoring
Module 4. SQL Server IO
- Troubleshooting tempdb
- Monitoring IO
Module 5. Query Optimization and
- Cardinality Estimation
- Working with Statistics
- Query Optimization
- Query Execution
- Plan Caching and Recompilation
Module 6.SQL Server Indexes and Query Plan Analysis
- Execution Plan Basics
- Index Analysis
- Index Fragmentation
- Analyzing Execution Plans
Module 7. SQL Server Concurrency
- Locking, Latching and Spinlocks
- Deadlocks and Blocking
- Monitoring Concurrency
- Transaction Isolation Levels
- Snapshot Isolation and Row Versioning
- Locking Hints