Loading...

Terminy kursów:

23.10.2023 - 26.10.2023
13.11.2023 - 16.11.2023
11.12.2023 - 14.12.2023

Pozostałe szkolenia

MS-10987 Performance Tuning and Optimizing SQL Databases

Czas trwania kursu: 4 dni
Cena: 2399 zł netto

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