您当前的位置：首页 > sqlserver数据库 > 文章详情

SQL SERVER查看数据库中哪个表占用的数最多空间最多

2023-08-08共1055人围观
sql server sql 数据库

SELECT

    t.NAME AS 你的表名,

    p.rows AS RowCounts,

    SUM(a.total_pages) * 8 AS TotalSpaceKB,

    SUM(a.used_pages) * 8 AS UsedSpaceKB,

    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB

FROM

    sys.tables t

INNER JOIN     

    sys.indexes i ON t.OBJECT_ID = i.object_id

INNER JOIN

    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id

INNER JOIN

    sys.allocation_units a ON p.partition_id = a.container_id

WHERE

    t.NAME NOT LIKE 'dt%'

    AND t.is_ms_shipped = 0

    AND i.OBJECT_ID > 255

GROUP BY

    t.NAME, p.Rows

ORDER BY

    TotalSpaceKB DESC;


上一篇： 如何设置sql server 2016数据库每天指定时间自动备份数据?

下一篇： Sql Server如何清空日志文件？

相关文章

文章评论

热门评论
暂无评论

文章分类

热门标签

随便看看

友情链接