Browse by Tags

• connect
• memory
• performance
• plan
• 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

Recompile all the stored procedures
27 April 07 06:42 AM | SQL Master | 0 Comments   

There has been many instances of requests from the Developers to recompile a set of Stored Procedures on one of the mission critical databases, due to the performance issues the relevant SPs have been fine tuned for optimum performance. In order to take Read More...

Filed under: ssms, performance, sql server, connect, management, cache