BUG: Enterprise Manager May Incorrectly Calculate Index Size (247490)
The information in this article applies to:
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: | Major | Last Reviewed: | 9/4/2002 |
---|
Keywords: | kbbug KB247490 |
---|
|