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?
views:
33answers:
1
+4
A:
DBCC FREEPROCCACHE
and DBCC DROPCLEANBUFFERS
This applies from at least SQL Server 2000
gbn
2010-03-30 18:07:21
That is what I was looking for. Thank you. I just couldn't remember them.
uriDium
2010-03-30 19:26:54