Browse by Tags

• error
• indexes
• integration
• management
• memory
• message
• package
• query
• security
• sql server

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

SQL Server has encountered '%' occurrence(s) of cachestore flush for the '%' cachestore
14 May 07 03:22 AM | SQL Master | 0 Comments   

One of our Operational Staff has alerted stating they see lot of following message on one of the SQL Server. SQL Server has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore For a moment I was bit perplxed with the message content Read More...

Filed under: plan, cache, perfmance, message, error

Reset cached plan - how to and what to?
14 May 07 01:53 AM | SQL Master | 1 Comments   

I don't believe you would need to reset the cache on a production server, it is not a best practice to perform in this case. Most of the times in development or test environments for the purpose of benchmarking you would need to reset the cache for optimum Read More...

Filed under: sql server, plan, integration, package, cache, memory, indexes, perfmance

Cached query plans and top stored procedures that are recompiled
11 May 07 04:02 AM | SQL Master | 4 Comments   

We all know that the cached query plans are good to go to attain the performance and no doubt that inefficient query plan will cause more distress to performance with an increased spike in CPU consumption. At the same occurrence of recompilation of a Read More...

Filed under: perfmance, sql server, query, plan, package, cache, indexes