Index.SpaceUsed Property

Gets or sets the disk space used to store the index data in kilobytes.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Expensive)> _
Public ReadOnly Property SpaceUsed As Double
    Get
'Usage
Dim instance As Index
Dim value As Double

value = instance.SpaceUsed
[SfcPropertyAttribute(SfcPropertyFlags.Expensive)]
public double SpaceUsed { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Expensive)]
public:
property double SpaceUsed {
    double get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Expensive)>]
member SpaceUsed : float
function get SpaceUsed () : double

Property Value

Type: System.Double
An Int64 value that specifies the space used, in KB.

Remarks

Note

For indexes based on the UserDefinedTableType object the value of SpaceUsed property is zero. Also, if setting the property issues a dbcc command it will not be executed.