Database.RecalculateSpaceUsage Method

Artikel
12/15/2008

Recalculates space usage.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Sub RecalculateSpaceUsage

public void RecalculateSpaceUsage ()

public:
void RecalculateSpaceUsage ()

public void RecalculateSpaceUsage ()

public function RecalculateSpaceUsage ()

Hinweise

Aktualisierter Text:17. Juli 2006

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

Der Namespace, die Klasse oder das Element wird nur in der Version 2.0 von Microsoft .NET Framework unterstützt.

Beispiel

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

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

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

Threadsicherheit

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.