SQL-DMO
IndexSpaceUsage Property
The IndexSpaceUsage property returns the number of kilobytes assigned to index storage within all operating system files maintaining indexes for the referenced database.
Applies To
Database Object |
Syntax
object.IndexSpaceUsage
Parts
object
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 may use all or part of the assigned storage.