This configuration option controls how SQL Server caches execution plans of ad-hoc (nonparameterized)
queries. When it is disabled (by default), SQL Server caches full execution plans of those statements, which may significantly increase plan cache memory usage. As the opposite, when this setting is enabled,
SQL Server starts by caching the small structure (just a few hundred bytes) called plan stub, replacing it with the full execution plan if an ad-hoc query is executed the second time.
Categories:
Tags:
No responses yet