DBCC commands to free several SQL Server memory caches:
DBCC FREESYSTEMCACHE
Releases all unused cache entries from all caches. The SQL Server 2005 Database Engine proactively cleans up unused cache entries in the background to make memory available for current entries.
DBCC FREESESSIONCACHE
Flushes the distributed query connection cache used by distributed queries against an instance of Microsoft SQL Server.
DBCC FREEPROCCACHE
Removes all elements from the procedure cache.
Reference : Pinal Dave (http://blog.SQLAuthority.com) ,BOL
can we use dbcc FREESYSTEMCACHE
dbcc FREESESSIONCACHE
dbcc FREEPROCCACHE
commands can be used in production server
Hi Pinal,
What are the parameters that can be passed to along with ‘FREESYSTEMCACHE’.??
When I simply run the query ‘DBCC FREESYSTEMCACHE’, I got the following error message
Msg 2583, Level 16, State 3, Line 1
An incorrect number of parameters was given to the DBCC statement.
Regards ,
Biju.K.S
DBCC FREESYSTEMCACHE (‘ALL’) WITH MARK_IN_USE_FOR_REMOVAL;
paste this as it is and it will clean up the buffers
– Clean all the caches with entries specific to the resource pool named “default”.
DBCC FREESYSTEMCACHE (‘ALL’,'default’)
1). May i run this query on every page???
2). This will affect the performance????