Clearing Out Memory : DBCC « System Settings « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Settings
  3. DBCC
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
GO

The DBCC FREEPROCCACHE command removes all elements from procedure cache so that any new query will require recompi
lation.
The DBCC DROPCLEANBUFFERS command removes clean buffers from the buffer pool.








26.4.DBCC
26.4.1.Using DBCC CHECKIDENT to View and Correct IDENTITY Seed Values
26.4.2.Clearing Out Memory
26.4.3.DBCC TRACEON
26.4.4.DBCC SHOW STATISTICS (tablename, index_name)
26.4.5.dynamically building the DBCC command:
26.4.6.Displaying the Oldest Active Transaction with DBCC OPENTRAN and Viewing Lock Activity
26.4.7.Syntax for Retrieving the Current IDENTITY Value of a Table and the Correct Value
26.4.8.Reseeding the IDENTITY Value
26.4.9.Syntax for Reseeding the IDENTITY Value with a New Explicit Value
26.4.10.Flushing the Procedure Cache