После окончания курса Вы будете уметь:
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: Concurrency and Transactions
Module 6: Statistics and Index Internals
Module 7: Extended Events
Module 8: Monitoring, Tracing and Baselining
Module 9: Troubleshooting Common Performance Issues
Module 10: Query Execution and Query Plan Analysis
Module 11: Plan Caching and Recompilation
Module 12: Index and Query Tuning
Module 1: SQL Server Architecture, Scheduling and Waits
SQL Server Components and SQL OS
Windows Scheduling vs SQL Scheduling
Waits and Queues
Lab : Exploring SQL Server Components and SQL OS
Lab : Monitor Schedulers and User requests
Lab : Monitor and record wait statistics
Module 2: SQL Server I/O
Core Concepts
Storage Area Networks
IO Setup and Testing
Lab : Testing Storage Performance
Module 3: Database Structures
Database Structure Internals
Data File Internals
TempDB Internals
Lab : Exploring Database Structure Internals
Lab : Enabling Instant File Initialization
Lab : Reducing TempDB Latch Contention
Module 4: SQL Server Memory
Windows Memory
SQL Server Memory
Lab : SQL Server Memory
Module 5: Concurrency and Transactions
Concurrency and Transactions
Locking Internals
Lab : Implement Snapshot Isolation
Lab : Locking Internals
Module 6: Statistics and Index Internals
Statistics Internals and Cardinality Estimation
Index Internals
Lab : Statistics Internals and Cardinality Estimation
Lab : Index Internals
Module 7: Extended Events
Extended Events core concepts
Implementing Extended Events
Lab : Extended Events core concepts
Lab : Implementing Extended Events
Module 8: Monitoring, Tracing and Baselining
Monitoring and Tracing
Baselining and Benchmarking
Lab : Monitoring and Tracing
Lab : Baselining and Benchmarking
Module 9: Troubleshooting Common Performance Issues
Troubleshooting CPU Performance
Troubleshooting Memory Performance
Troubleshooting I/O Performance
Troubleshooting TempDB Performance
Troubleshooting Concurrency Performance
Lab : Troubleshooting CPU Performance
Lab : Troubleshooting Memory Performance
Lab : Troubleshooting IO Performance
Lab : Troubleshooting TempDB Performance
Lab : Troubleshooting Concurrency Performance
Module 10: Query Execution and Query Plan Analysis
Query Execution and Optimizer Internals
Analyzing Query Plans
Lab : Analyzing Query Plans
Module 11: Plan Caching and Recompilation
Plan Cache Internals
Troubleshooting Plan Cache Issues
Lab : Troubleshooting Plan Cache Issues
Module 12: Index and Query Tuning
Index Fragmentation
Indexing Techniques
Indexing Strategy
Lab : Index Fragmentation
Lab : Indexing Techniques
Lab : Indexing Strategy
Lab : Tuning Queries
