PROCEDURE CACHE AND BUFFER CACHE INFORMATION

–plays information in a table format about the procedure cache.
DBCC PROCCACHE

–Removes all elements from the procedure cache.
DBCC FREEPROCCACHE

–Removes all clean buffers from the buffer pool.
DBCC DROPCLEANBUFFERS

Update me when site is updated

Leave a Reply

You must be logged in to post a comment.