开发者

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

开发者 https://www.devze.com 2022-12-25 06:37 出处:网络
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 som

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

精彩评论

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

关注公众号