mssql sqlserver 释放缓存脚本的方法收集


摘要:
下文展示释放缓存脚本的方法,如下所示:


  
DBCC FREESYSTEMCACHE('all')WITH MARK_IN_USE_FOR_REMOVAL 
GO 

DBCC FREESESSIONCACHE WITH NO_INFOMSGS 
GO 

DBCC FREEPROCCACHE WITH NO_INFOMSGS 
GO 

DBCC DROPCLEANBUFFERS 
GO