BUG: Enterprise Manager May Incorrectly Calculate Index Size (247490)



The information in this article applies to:

  • Microsoft SQL Server 7.0

This article was previously published under Q247490
BUG #: 56896 (SQLBUG_70)

SYMPTOMS

When you click a database within the SQL Enterprise Manager (SEM), and then you select Table Indexes in the right pane, the index size that displays may be incorrect for non-clustered indexes.

WORKAROUND

You can use the stored procedure sp_spaceused to obtain the total space used by the indexes. There is not a supported way to calculate the space used by each index.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

Modification Type:MajorLast Reviewed:9/4/2002
Keywords:kbbug KB247490