SqlServer数据库收缩tempdb

USE [tempdb]
select name, convert(float,size) * (8192.0/1024.0)/1024 from dbo.sysfiles
GO
DBCC FREESYSTEMCACHE ('ALL')
GO
DBCC SHRINKFILE (N'templog' , 80)
DBCC SHRINKFILE (N'tempdev' , 8000)
DBCC SHRINKFILE (N'temp2' , 8000)
DBCC SHRINKFILE (N'temp3' , 8000)
DBCC SHRINKFILE (N'temp4' , 8000)
DBCC SHRINKFILE (N'temp5' , 8000)
DBCC SHRINKFILE (N'temp6' , 8000)
DBCC SHRINKFILE (N'temp7' , 8000)
DBCC SHRINKFILE (N'temp8' , 8000)
GO