SQLServer: 如何查看表占用空间大小

--定义表变量
DECLARE @T TABLE
(
	[name]           VARCHAR(max),[rows]           INT,reserved         VARCHAR(max),data_size        VARCHAR(max),index_size       VARCHAR(max),unused           VARCHAR(max)
)

--将表占用情况存放到表变量
INSERT INTO @T
EXEC sp_MSforeachtable "exec sp_spaceused '?'"

SELECT [name],[rows],reserved,data_size,index_size,unused,CAST(REPLACE(reserved,'KB','') AS INT)/1024 as reserved_MB,CAST(REPLACE([data_size],'') AS INT)/1024 as data_size_MB,CAST(REPLACE([index_size],'') AS INT)/1024 as index_size_MB,CAST(REPLACE([unused],'') AS INT)/1024 as unused_MB
FROM @T
order by CAST(REPLACE(reserved,'') AS INT) desc

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!