On January 28, 2021 I will run an SQLpassion Online Training about Statistics & Plan Caching in SQL Server. 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 I 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. Please check-out the this link for more details about the online training (detailed agenda, date, pricing) and how to sign-up.
Thanks for your time,
Klaus