[SQL Server] Taille des index
SELECT
OBJECT_NAME(i.object_id) AS nom_table, i.[name] AS IndexName
,SUM(s.[used_page_count]) * 8.0 AS IndexSize_KB
,(SUM(s.[used_page_count]) * 8.0)/1024 AS IndexSize_MO
,((SUM(s.[used_page_count]) * 8.0)/1024)/1024 AS IndexSize_GO
FROM sys.dm_db_partition_stats AS s
INNER JOIN sys.indexes AS i ON s.[object_id] = i.[object_id]
AND s.[index_id] = i.[index_id]
--where i.[name]='MonIndexe'
WHERE OBJECT_NAME(i.object_id) IN ('Table1','Table2')
GROUP BY OBJECT_NAME(i.object_id) ,i.[name]
ORDER BY OBJECT_NAME(i.object_id),i.[name]