Pages

Saturday, September 21, 2013

SQL SERVER – DBCC commands to free several SQL Server memory caches | Journey to SQL Authority with Pinal Dave

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… Continue Reading...

Source: SQL SERVER – DBCC commands to free several SQL Server memory caches | Journey to SQL Authority with Pinal Dave