Training agenda
  1.  SQL Server Architecture, Scheduling, and Waits

    • SQL Server Components and SQL OS
    • Windows Scheduling vs SQL Scheduling
    • Waits and Queues
  2.  SQL Server I/O

    • Core Concepts
    • Storage Solutions
    • I/O Setup and Testing
  3.  Database Structures

    • Database Structure Internals
    • Data File Internals
    • TempDB Internals
  4.  SQL Server Memory

    • Windows Memory
    • SQL Server Memory
    • In-Memory OLTP
  5.  SQL Server Concurrency

    • Concurrency and Transactions
    • Locking Internals
  6. Statistics and Index Internals

    • Statistics Internals and Cardinality Estimation
    • Index Internals
    • Columnstore Indexes
  7.  Query Execution and Query Plan Analysis

    • Query execution and optimizer internals
    • Query execution plans
    • Analyzing query execution plans
    • Adaptive query processing
  8.  Plan Caching and Recompilation

    • Plan cache internals
    • Troubleshooting plan cache issues
    • Automatic tuning
    • Query store
  9.  Extended Events

    • Extended events core concepts
    • Working with extended events
  10. Monitoring, Tracing, and Baselining

    • Monitoring and tracing
    • Baselining and benchmarking