views:

33

answers:

1

I want to do some SQL Server performance testing and I want to establish a good baseline. I want to flush all the caches each time so that I know between each test it hasn't cached something so it performs better in between runs. Which DBCC commands should I use to make my SQL server as clean as possible?

+4  A: 

DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS

This applies from at least SQL Server 2000

gbn
That is what I was looking for. Thank you. I just couldn't remember them.
uriDium