Microsoft KB Archive/247490

From BetaArchive Wiki
Knowledge Base

BUG: Enterprise Manager May Incorrectly Calculate Index Size

Article ID: 247490

Article Last Modified on 9/4/2002


  • Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q247490

BUG #: 56896 (SQLBUG_70)


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.


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.


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

Additional query words: usage mmc gui

Keywords: kbbug kbpending KB247490