Свойство Table.DataSpaceUsed

Статья
04/26/2013

Gets the storage space used by the rows of the referenced table in kilobytes.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property DataSpaceUsed As Double 
    Get
'Применение
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

Значение свойства

Тип: System.Double
A Float64 value that specifies the storage space of the rows of data in the table, in kilobytes.

Замечания

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.

Примеры

The following code example shows how to display the amount of storage space used by each table in the AdventureWorks2012 database.

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

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("AdventureWorks2012")

Foreach ($tb in $db.Tables)
{
   Write-Host "The" $tb.Name "table is" $tb.DataSpaceUsed "KB in size."
}