IndexSpaceUsage Property
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The IndexSpaceUsage property returns the number of kilobytes assigned to index storage within all operating system files maintaining indexes for the referenced database.
Sintaxis
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);
Comentarios
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.