Optimize for Ad-Hoc Workloads

Optimize for Ad-Hoc Workloads

SQL Server is using part of its memory for storing execution plans of the queries that can be used repeatedly without recompilation. Every compilation of execution plan has its cost including system resources mostly CPU, so it is saving time by caching execution plans for their reuse, this part of memory is called procedure cache. More info about this mechanism can be found in technet article Execution Plan Caching and Reuse. Now lets consider situation when there are many queries running over SQL Server database, and most of these queries are totally different each other and running not too often, but...
Read More