21 May 2026 (Thursday)
Session Title: Understanding Plan-Level Properties Part-2
(Free 60-minute session)
Abstract: Gain a sharper edge in SQL Server performance tuning by mastering Plan-Level Properties—the hidden metadata that reveals how your queries truly execute. In this one-hour webinar, we will decode the rich set of properties embedded within execution plans, helping you move beyond surface-level analysis into precise, insight-driven optimization.
You’ll learn how to interpret critical attributes such as estimated vs. actual rows, memory grants, degree of parallelism, optimizer choices, and execution warnings. We will also explore how these properties reflect the internal decision-making of the SQL Server optimizer, and how they can be leveraged to diagnose bottlenecks, uncover inefficiencies, and validate tuning efforts.
Through practical demonstrations and real-world troubleshooting scenarios, this session will equip you to read execution plans with confidence, identify subtle performance issues, and take targeted corrective actions.
If you want to stop guessing and start understanding exactly why SQL Server behaves the way it does, this webinar will give you the clarity and tools to do so effectively.
Spread the word: Share on LinkedIn. Tweet now. Share on Facebook.
Level: 300
Trainer: Amit Bansal
| Date: 21 May 2026 Time: 11.30 am EDT | 10:30 am CDT | 8.30 am PDT | 4.30 pm GMT | 9 pm IST View in your time zone Download Calendar |
28 May 2026 (Thursday)
Session Title: Understanding Operator-Level Properties in SQL Server
(Free 60-minute session)
Abstract: Take your SQL Server performance tuning skills to the next level by uncovering the power of Operator-Level Properties within execution plans. While execution plans visually display the flow of a query, the real story lies inside the detailed properties of each operator—where SQL Server exposes exactly how data is processed, estimated, and optimized.
In this one-hour webinar, we will explore the critical operator-level metrics and attributes that help diagnose performance bottlenecks with precision. Learn how to interpret properties such as estimated and actual row counts, predicate details, seek vs. residual operations, rewinds, rebinds, memory usage, I/O costs, parallelism behavior, and operator warnings.
Through demos, Amit Bansal will show how these properties reveal hidden inefficiencies, inaccurate estimations, missing indexes, spills to tempdb, and other issues that directly impact query performance.
Whether you are a DBA, developer, or performance tuning enthusiast, this session will help you move beyond simply “reading” execution plans to truly understanding the internal mechanics of SQL Server query execution—allowing you to troubleshoot smarter and optimize faster.
Spread the word: Share on LinkedIn. Tweet now. Share on Facebook.
Level: 300
Trainer: Amit Bansal
| Date: 28 May 2026 Time: 11.30 am EDT | 10:30 am CDT | 8.30 am PDT | 4.30 pm GMT | 9 pm IST View in your time zone Download Calendar |
More Learning Opportunities
