DBCC FreeProcCache & DBCC DROPCLEANBUFFERS

Posted Date: 03 Oct 2008	Resource Type: Articles	Category: Databases
Author: Vignesh	Member Level: Silver
Rating:	Points: 3

DBCC FreeProcCache:

This DBCC command flushes out already cached plans. This command is useful when we want to view a particular query’s cache plan alone. After this command is run SQL statement recompiles instead of re-using the cache available already.

syscacheobjects table is used to list all the cache details in the database. This table will be cleared after the execution of ‘DBCC FreeProcCache’ statement.
Following query is used to list the cache details,

SELECT cacheobjtype,objtype,sql FROM syscacheobjects

DBCC DROPCLEANBUFFERS:

This command is used to clear buffers from the buffer pool.

These above 2 commands are useful when the performance tuning of some slow running query/SP is being analyzed. These commands are to be run between 2 subsequent code changes.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Sql .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Difference between DELETE and TRUNCATE COmmand
	Previous Resource: Encryption and Comparison of Data in SQL Server 2000
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources