CPS0204
註冊時間: 2014-08-24 文章: 451
第 1 樓
|
發表於: 星期一 九月 21, 2015 9:12 pm 文章主題: 可以快速查得您的table佔去SQL的磁碟容量 |
|
|
USE your_database
CREATE TABLE #t
( [name] NVARCHAR(128), [rows] CHAR(11), reserved VARCHAR(20 ),
data VARCHAR(20), index_size VARCHAR(20), unused VARCHAR(20))
GO
INSERT #t
EXEC [sys].[sp_MSforeachtable] 'EXEC sp_spaceused "?"'
GO
SELECT
name as TableName,
Rows,
ROUND(CAST(REPLACE(reserved, ' KB', '') as float) / 1024,2) as ReservedMB,
ROUND(CAST(REPLACE(data, ' KB', '') as float) / 1024,2) as DataMB,
ROUND(CAST(REPLACE(index_size, ' KB', '') as float) / 1024,2) as IndexMB,
ROUND(CAST(REPLACE(unused, ' KB', '') as float) / 1024,2) as UnusedMB
FROM #t
ORDER BY CAST(REPLACE(reserved, ' KB','') as float) DESC
GO
select * from #t order by name
go
Drop table #t |
|