C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

DBCC FreeProcCache & DBCC DROPCLEANBUFFERS

Posted Date: 03 Oct 2008 Resource Type: Articles Category: Databases

Posted By: 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: difference between MSSQL and MYSQL
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj