阅读背景:

我可以清理某些指定数据库的缓冲区而不是整个sql server

来源:互联网 

from what i know, if i execute 'DBCC FREEPROCCACHE' and 'DBCC DROPCLEANBUFFERS', the buffer of entire server will be cleanup. i wonder if there's anyway to cleanup buffer of specified database only. therefore, query for other databases will not be affected.from what i know, if i execute 'DBCC FREEPROCCA




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: