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)

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Expensive | SfcPropertyFlags.Standalone)]
public double SpaceUsed { get; }

Property Value

Type: System.Double

An Int64 value that specifies the space used, in KB.

System_CAPS_noteNote

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.

Return to top
Show: