Database.RecalculateSpaceUsage Database.RecalculateSpaceUsage Database.RecalculateSpaceUsage Method

Definition

Recalculates space usage.

public:
 void RecalculateSpaceUsage();
public void RecalculateSpaceUsage ();
Public Sub RecalculateSpaceUsage ()

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

'Recalculate space usage.  
db.RecalculateSpaceUsage()  

'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  

Remarks

This method updates and recalculates the space used by indexes and data within the database.

Applies to