Statistics & Plan Caching

Statistics are used by SQL Server to estimate how many rows are returned for a given query. Based on that assumption, the Query Optimizer compiles a physical Execution Plan, which is finally executed by SQL Server. The generated Execution Plan is also cached in the so- called Plan Cache for further reuse.

Because of this approach, a lot of different performance problems can occur in SQL Server, especially then when an inefficient Execution Plan is generated and reused over the time. During the webinar we will cover the following areas:

  • Statistics
    • Auto Create
    • Auto Update
    • Statistics Analysis
    • Multi Column Statistics
  • Cardinality Estimation
    • Conjunctions
    • Disjunctions
    • Ascending Key Column Problem
  • Plan Caching
    • Adhoc Query Caching
    • Parameterization
    • Optimize for Adhoc Workloads
  • Parameter Sniffing
    • Local Variables
    • Recompilations
    • Plan Guides

This one-day long webinar is primarily for DBAs, Developers, and Consultants who want to make their SQL Server installations faster.

Date & Pricing Details:

  • Time: January 28, 2021 from 09:00am to 05:00pm (GMT + 1)
  • Live Web-Based Training
  • EUR 490 + 20% VAT