Browse by Tags

• cache
• memory
• performance
• query
• security
• sql server
• ssms

What events will cause a flushing of plan in cache?
14 May 07 05:17 AM | SQL Master | 3 Comments   

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. Read More...

Filed under: sql server, security, management, plan, cache, memory, perfmance

Execution plans caching and how SQL optimizer reuses for better performance
25 April 07 01:16 PM | SQL Master | 1 Comments   

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 Read More...

Filed under: ssms, performance, sql server, management, query, plan