Database.DataSpaceUsage Property
Gets the space used by the data in the database.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
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
Show: