SELECT*FROM(SELECT
DB_NAME(database_id)AS DatabaseName,
type_desc AS FileType,
name AS FileName,
size *8/1024/1024AS FileSizeGB
FROM sys.master_files
WHEREtype=0-- 数据文件AND state =0-- 在线状态) T1 ORDERBY FileSizeGB DESC
SqlServer 查询数据表 大小
SELECT
t.NAME AS TableName,
s.Name AS SchemaName,
p.rowsAS RowCounts,CONVERT(decimal(18,2),SUM(a.total_pages)*8.0/1024/1024)AS TotalSpaceGB,CONVERT(decimal(18,2),SUM(a.used_pages)*8.0/1024/1024)AS UsedSpaceGB,CONVERT(decimal(18,2),(SUM(a.total_pages)-SUM(a.used_pages))*8.0/1024/1024)AS UnusedSpaceGB
FROM
sys.tables t
INNERJOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNERJOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNERJOIN
sys.allocation_units a ON p.partition_id = a.container_id
LEFTOUTERJOIN
sys.schemas s ON t.schema_id = s.schema_id
GROUPBY
t.NAME, s.Name, p.RowsORDERBY
TotalSpaceGB DESC;