MC 40 Hours


SQL Server Performance Tuning Master Class (Online)

Trainer(s): Amit Bansal
Provider: SQLMaestros
Duration: 40 Hours
Subtitles: No
Price: USD 249 (Click Here for More Discount)
Date: 14 – 25 March
Type: Master Class

Have you ever been to Army-Training? When was the last time you had a brain-melting experience? Welcome to the most rigorous SQL training you ever had. This 40-hour course is designed to give you the right amount of internals and loads of practical tuning & optimization techniques that you can put into production right away. The course will be taught by Amit Bansal, Microsoft Certified Master of SQL Server. As part of the class, all participants will get a 1-year FREE subscription to SQLMaestros Video Courses.

Modules

    1. SQL Server Architecture, Scheduling & Waits

    • SQL Server Components and SQL OS
    • Waits and Queues
    • Query Lifecycle
    • Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
    • Common Wait Types in SQL Server, identification & diagnosis

    2. CPU Performance Monitoring & Tuning

    • Troubleshooting CPU Performance
    • Identifying, troubleshooting & tuning workload patterns that cause excessive CPU

    3. SQL Server Tempdb Internals & Tuning

    • Tempdb Internals
    • Identifying, troubleshooting & tuning workload patterns that cause excessive Tempdb usage

    4. SQL Server I/O Internals & Tuning

    • Core Concepts
    • IO Setup and Testing
    • SQL Server IO Patterns
    • Identifying, troubleshooting & tuning workload patterns that cause excessive IO

    5. SQL Server Memory Internals & Troubleshooting

    • Windows Memory Internals
    • SQL Server Memory Internals & Troubleshooting
    • Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage

    6. Concurrency and Transactions

    • Concurrency and Transactions
    • Locking Internals
    • Troubleshooting Blocking Scenarios
    • Troubleshooting Deadlocks

    7. Query Execution and Query Plan Analysis

    • Query Execution and Optimizer Internals
    • Analyzing Query Plans

    8. Statistics and Index Internals

    • Statistics Internals
    • Cardinality Estimation Internals
    • Index Internals

    9. Query Tuning

    • Understanding common patterns & antipatterns
    • Troubleshooting Slow Running Queries
    • Identify Plan Quality Issues
    • Optimizing T-SQL code/Rewriting
    • Optimizing Stored Procedures
    • Real-World Query Tuning Examples

    10. Index Tuning

    • Indexing Techniques
    • Indexing Strategies
    • Real World Index Tuning Examples

    11. Plan Caching and Recompilation

    • Plan Cache Internals
    • Troubleshooting Plan Cache Issues

    12. Extended Events

    • Extended Events core concepts
    • Implementing Extended Events

    13. Monitoring, Tracing and Baselining

    • Tools & Techniques
    • Monitoring and Tracing
    • Baselining and Benchmarking

    14. SQL Server New Features

    • New Tuning Features in Latest Versions of SQL Server

Note: This recorded class is available in the format of a video course. Content is presented in modular videos. Learn more.