Database.DataSpaceUsage Database.DataSpaceUsage Database.DataSpaceUsage Property

Definition

Gets the space used by the data in the database.

public:
 property double DataSpaceUsage { double get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Expensive | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone)]
public double DataSpaceUsage { get; }
Public ReadOnly Property DataSpaceUsage As Double
Property Value

A Double value that specifies the amount of space used by the data, in KB.

Examples

VB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Display size and space information for the database.  
Console.WriteLine("data space usage (KB): " + _  
db.DataSpaceUsage.ToString)  
Console.WriteLine("index space usage (KB): " + _  
db.IndexSpaceUsage.ToString)  
Console.WriteLine("space available (KB): " + _  
db.SpaceAvailable.ToString)  
Console.WriteLine("database size (MB): " + _  
db.Size.ToString)  

PowerShell

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

Write-Host "data space usage (KB):" $db.DataSpaceUsage  
Write-Host "index space usage (KB):" $db.IndexSpaceUsage  
Write-Host "space available (KB):" $db.SpaceAvailable  
Write-Host "database size (MB):" $db.Size  

Applies to