Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL Server caches the execution plans for queries in an area of memory called the

Newtablink
aliasplan cache.
urlhttp://technet.microsoft.com/en-us/library/cc293624.aspx
When a server executes a large number of single-use queries, which can be a common scenario for certain applications, the space used caching these various execution plans can grow quite large, possibly impacting server performance for very little benefit.

...