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 |
|
pvsramu
Starting Member
17 Posts |
 Posted - 2007-01-19 : 15:38:54
|
| Hi,I would like to disable the buffer cache. How to do that? We have setup load test where 40 connections with "same user activities" are concurrently hitting the database. The problem is, the "set of activities" are same for all connections and worried whether the data will be buffered? and it wont be real test for performance?Thanks,Ramu |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-19 : 15:40:18
|
| I don't believe that it can be disabled. You can clear it out though:DBCC DROPCLEANBUFFERSDBCC FREEPROCCACHEWe do that in between each performance run to get accurate results.Tara Kizer |
 |
|
|
|
|
|
disable buffer cache