1999zł
KLUCZOWE ZAGADNIENIA
- architektura środowiska i bazy danych
- zarządzanie pamięcią
- indeksy i statystyki
- monitorowanie SQL Server
- plany wykonania, rekompilacja zapytań
- diagnozowanie problemów z wydajnością
Przemysław Rosłon Microsoft Certified Trainer
POZIOM SZKOLENIA
| podstawowy |
średniozaawansowany |
zaawansowany |
ekspercki |
| 100 |
200 |
300 |
400 |
TEMATYKA ZAJĘĆ
- Module 1: SQL Server Architecture, Scheduling, and Waits
SQL Server Components and SQL OS
Windows Scheduling vs SQL Scheduling
Waits and Queues
Lab : SQL Server Architecture, Scheduling, and Waits
- Module 2: SQL Server I/O
Core Concepts
Storage Solutions
I/O Setup and Testing
Lab : Testing Storage Performance
- Module 3: Database Structures
Database Structure Internals
Data File Internals
TempDB Internals
Lab : Database Structures
- Module 4: SQL Server Memory
Windows Memory
SQL Server Memory
In-Memory OLTP
Lab : SQL Server Memory
- Module 5: SQL Server Concurrency
Concurrency and Transactions
Locking Internals
Lab : SQL Server Concurrency
- Module 6: Statistics and Index Internals
Statistics Internals and Cardinality Estimation
Index Internals
Columnstore Indexes
Lab : Statistics and index Internals
- Module 7: Query Execution and Query Plan Analysis
Query execution and optimizer internals
Query execution plans
Analyzing query execution plans
Adaptive query processing
Lab : Query execution and query plan analysis
- Module 8: Plan Caching and Recompilation
Plan cache internals
Troubleshooting plan cache issues
Automatic tuning
Query store
Lab : Plan caching and recompilation
- Module 9: Extended Events
Extended events core concepts
Working with extended events
Lab : Extended events
- Module 10: Monitoring, Tracing, and Baselining
Monitoring and tracing
Baselining and benchmarking
Lab : Monitoring, Tracing and Baselining