MS-10987 Performance Tuning and Optimizing SQL Databases

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

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