SQL Server

SQL Server Performance Tuning – Fast Track (Online)

Trainer(s): Amit Bansal
Provider: SQLMaestros
Duration: 8 Hours
Subtitles: No
Price: USD 249 (Click Here for More Discount)
Date: 9 & 10 March
Type: Master Class
Subscription Period: Lifetime Access

One fine day you realize that you have to start tuning SQL Server for better performance. The need might have arisen from a recent performance issue, or the barrage of support tickets that are filling your inbox, or maybe your boss assigned this to you after realizing that SQL Server performance troubleshooting is not his cup of tea. Irrespective of the reason, the challenge is upon you to identify, diagnose and fix a variety of performance issues that are plaguing your SQL Server environment.

Performance troubleshooting can be categorized as proactive, real-time & reactive. If a well-defined methodology is followed during the proactive phase, you will have less fire-fighting during the real-time troubleshooting phase and you will have a lot of meaningful performance data to work within the reactive phase, which will further help you in preventing performance cases.

Join this demo-filled, 8-hour class, where you will learn the three approaches of SQL Server performance troubleshooting & tuning. You will learn the practical way, exactly like how you would troubleshoot in the real world with lots of code and scripts. Amongst many takeaways, here are some interesting ones:

  • Develop a performance troubleshooting methodology for the real-world
  • Learn how to benchmark and baseline (and also take away a framework, ready-to-use)
  • Analyzing and troubleshooting common wait types
  • Proactive, reactive, and real-time CPU troubleshooting
  • Troubleshooting IO performance bottlenecks
  • Tracking SQL Server memory consumption and fixing OOM errors
  • Dealing with Tempdb madness
  • Top 6 query tuning techniques that will solve 75% of performance issues (real-world query tuning)
  • Top 3 indexing strategies that will fix 60% indexing woes
  • Get rid of deadlocks (yes, you hear it right)
  • SQL Server 2019 performance enhancements


    1. Core Concepts

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

    2. The Foursome – CPU, Memory, IO & Tempdb

    • Identifying, troubleshooting & tuning workload patterns that cause excessive CPU
    • Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage
    • Identifying, troubleshooting & tuning workload patterns that cause excessive IO
    • Identifying, troubleshooting & tuning workload patterns that cause excessive Tempdb usage

    3. Query Execution & Query Plan Analysis

    • Statistics & Cardinality Estimation
    • Reading & Analysing Execution Plans
    • Important Iterators

    4. Index Tuning

    • Demystifying Common Myths with Indexes
    • Indexing Strategies
    • Index Fragmentation
    • Real-World Index Tuning Examples

    5. Query Tuning

    • Rewriting Transact-SQL
    • Dealing with Implicit Conversions
    • Sargability
    • Solving Parameter Sniffing Issues
    • Parametrization Best Practices

    6. Dealing with Deadlocks

    • Common Deadlock Types
    • Deadlock Best Practices
    • Practical Deadlock Troubleshooting & Diagnosis

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