A Tsql script to help out...
SELECT fg.data_space_id , fg.name , OBJECT_NAME(p.object_id) AS [ObjectName] , p.index_id , dbf.name , dbf.physical_name , dbf.size*8/1024 AS [Size] -- Size of file -- size is in number of 8KB pages. Multiply by 8 to get figure per extent (64KB), -- then divide by 1024 to get index size in MB. FROM sys.filegroups fg LEFT JOIN sys.database_files dbf ON fg.data_space_id = dbf.data_space_id LEFT JOIN sys.partitions p ON fg.data_space_id = p.partition_number WHERE (p.object_id>4096 OR p.object_id IS NULL)
No comments:
Post a Comment