List Indexes and their size

SELECT OBJECT_NAME(i.OBJECT_ID)AS TableName,

i.name AS IndexName, i.index_id AS IndexID,

(8 *SUM(a.used_pages))/1024 AS 'Indexsize(MB)'

FROM sys.indexes AS i

JOIN sys.partitions AS p ON p.OBJECT_ID= i.OBJECT_ID AND p.index_id = i.index_id

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

GROUP BY i.OBJECT_ID, i.index_id,i.name

ORDER BY OBJECT_NAME(i.OBJECT_ID), i.index_id

MvM