开发者

Which DBCC commands do I need to run to make sure SQL Server's caches are totally clean?

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜