Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cache flushing
- Thread starter Souvik
- Start date
tlbroadbent
MIS
--Clear procedure cache
DBCC FREEPROCCACHE
--Remove all clean buffers from the buffer pool
DBCC DROPCLEANBUFFERS
Obviously, you don't want SQL to drop dirty buffers. These must be written to disk before they can be dropped. See SQL BOL for more details on these DBCC commands.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
DBCC FREEPROCCACHE
--Remove all clean buffers from the buffer pool
DBCC DROPCLEANBUFFERS
Obviously, you don't want SQL to drop dirty buffers. These must be written to disk before they can be dropped. See SQL BOL for more details on these DBCC commands.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
- Thread starter
- #3
Hi,
Regarding the dbcc dropcleanbuffers method, I see that inspite of running it, my physical reads are 0 & all the data is still read logically. I wanted to know if I can clean the all the pages & read from the db file on the disk & then wanted to measure the statistics for that.
Thanks again,
Regarding the dbcc dropcleanbuffers method, I see that inspite of running it, my physical reads are 0 & all the data is still read logically. I wanted to know if I can clean the all the pages & read from the db file on the disk & then wanted to measure the statistics for that.
Thanks again,
- Status
Similar threads