SpaceUsed Property
Collapse the table of content
Expand the table of content

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.

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.

Community Additions

ADD
Show:
© 2016 Microsoft