DataSpaceUsed-Eigenschaft
Ruft den Speicherplatz in Kilobytes ab, der von den Zeilen der Tabelle belegt wird, auf die verwiesen wird.
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 DataSpaceUsed As Double
Get
'Usage
Dim instance As Table
Dim value As Double
value = instance.DataSpaceUsed
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public double DataSpaceUsed { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property double DataSpaceUsed {
double get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member DataSpaceUsed : float
function get DataSpaceUsed () : double
Eigenschaftswert
Typ: System. . :: . .Double
Ein Float64-Wert, der den Speicherplatz der Datenzeilen in der Tabelle in Kilobytes angibt.
Hinweise
The value is the actual amount of disk space that is required to store the row data of the referenced table. SQL Server can allocate additional, unused space to a Table object.
Beispiele
The following code example shows how to display the amount of storage 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 is " + tb.DataSpaceUsed.ToString() + " KB in size.");
}
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 is" $tb.DataSpaceUsed "KB in size."
}
Siehe auch