|
|
Browse by Tags
All Tags » management » plan (RSS)
-
We already know that using DBCC FREEPROCCACHE will have the affect of flushing all the cache with immediate affect and also DBCC FREESYSTEMCACHE (new in SQL 2005) has similar affect but will flush the plans asynchronously that are marked as unused anymore. Also you would know that when a database is RESTORed or DETACHed then it will have same ...
-
Memory plays important role in Performance on a windows based platform, SQL Server 2005 features has a pool of memory that is used to store both execution plans and data buffers, only the part of memory is used to store execution plans that we call as 'procedure cache'. Query plan & Execution context are key ingredients for performance and ...
|
|
|