IndexSpaceUsage Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The IndexSpaceUsage property returns the number of kilobytes assigned to index storage within all operating system files maintaining indexes for the referenced database.
Syntax
object.IndexSpaceUsage
Parts
- object
An expression that evaluates to an object in the Applies To list
Data Type
Float
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetIndexSpaceUsage(LPFLOAT pRetVal);
Remarks
Microsoft SQL Server assigns database storage for index maintenance as indexes are created. A given index can use all or part of the assigned storage.