shrink temp db without reboot mssqlserver

来源:这里教程网 时间:2026-03-02 11:07:34 作者:
use tempdb


CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO


DBCC FREEPROCCACHE;
GO


DBCC FREESYSTEMCACHE ('ALL');
GO


DBCC FREESESSIONCACHE;
GO


DBCC SHRINKFILE (TEMPDEV2, 1024);   --- New file size in MB
GO



https://sqlsunday.com/2013/08/11/shrinking-tempdb-without-restarting-sql-server/

相关推荐