Freigeben über

  • Artikel

IndexSpaceUsed-Eigenschaft

Ruft den vom Index belegten Speicherplatz in KB ab.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property IndexSpaceUsed As Double
    Get
'Usage
Dim instance As Table
Dim value As Double

value = instance.IndexSpaceUsed

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

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property double IndexSpaceUsed {
    double get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member IndexSpaceUsed : float

function get IndexSpaceUsed () : double

Eigenschaftswert

Typ: System. . :: . .Double
Ein Float64-Wert, der den vom Index verwendeten Speicherplatz in KB angibt.

Beispiele

The following code example shows how to list the amount of index space used by each table in the AdventureWorks2008R2 database.

C#

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2008R2"];

foreach (Table tb in db.Tables) 
{
   Console.WriteLine("The " + tb.Name + " table has uses " + tb.IndexSpaceUsed.ToString() + " KB of index space.");
}

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")

Foreach ($tb in $db.Tables) 
{
   Write-Host "The" $tb.Name "table uses " $tb.IndexSpaceUsed " KB of index space."
}