1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | ------MSSQL查看数据库表的大小MB SELECT db_name() as DbName, t. NAME AS TableName, s. Name AS SchemaName, p. rows AS RowCounts, SUM (a.total_pages) * 8 AS TotalSpaceKB, CAST (ROUND((( SUM (a.total_pages) * 8) / 1024.00), 2) AS NUMERIC (36, 2)) AS 总共占用空间MB, SUM (a.used_pages) * 8 AS UsedSpaceKB, CAST (ROUND((( SUM (a.used_pages) * 8) / 1024.00), 2) AS NUMERIC (36, 2)) AS UsedSpaceMB, ( SUM (a.total_pages) - SUM (a.used_pages)) * 8 AS UnusedSpaceKB, CAST (ROUND((( SUM (a.total_pages) - SUM (a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC (36, 2)) AS UnusedSpaceMB 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 LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE t. NAME NOT LIKE 'dt%' AND t.is_ms_shipped = 0 AND i.OBJECT_ID > 0 GROUP BY t. Name , s. Name , p. Rows ORDER BY 总共占用空间MB desc |
本文为宁若水!原创文章,转载无需和我联系,但请注明来自[若水]博客 www.lalaya.net