We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent 96319d8 commit 48b5f95Copy full SHA for 48b5f95
QueryTemplates/Performance/index-fragmentation.sql
@@ -5,6 +5,7 @@ SELECT dbschemas.[name] as 'Schema',
5
indexstats.partition_number,
6
FORMAT(AVG(indexstats.avg_fragmentation_in_percent), 'N2') AS avg_fragmentation_in_percent,
7
FORMAT(SUM(indexstats.page_count), 'N0') AS page_count,
8
+ FORMAT(SUM(indexstats.page_count * 8 / 1024), 'N0') AS index_size_mb,
9
'ALTER INDEX ['+dbindexes.[name]+'] ON [' + dbschemas.name + '].['+dbtables.[name]+'] REORGANIZE PARTITION = '
10
+ CASE WHEN EXISTS(SELECT TOP 1 1 FROM sys.partition_schemes s WHERE s.data_space_id = dbindexes.data_space_id)
11
THEN CAST(indexstats.partition_number AS VARCHAR(3)) ELSE 'ALL' END + ';' AS CmdReorg,
0 commit comments