Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
 Posted - 2002-10-17 : 10:10:50
|
I thought this dbcc would clear the data cache, forcing any subsequent dml to access pages from disk.Using perfmon to monitor Buffer cache hit ratio, I'm not seeing this as the case...Which dbcc do you use to clear the cache to ensure fair testing between two dml statements?edit: nevermind, I wasn't testing a large enough dataset to see a blip in perfmon... a larger dataset and looking at %physical disk time, I see the disk access after the dbcc dropcleanbuffers ...Jay White{0}Edited by - Page47 on 10/17/2002 10:23:54 |
|
|
|
|
|
dbcc dropcleanbuffers