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 h开发者_JAVA百科asn'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?
DBCC FREEPROCCACHE
and DBCC DROPCLEANBUFFERS
This applies from at least SQL Server 2000
精彩评论