문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
|
번역
영문
|
Visual Studio 2017을 사용하는 것이 좋습니다.
Database.Size 속성
SQL Server 2012
Gets the size of the database in MB.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
The size is specified in megabytes and should be the same as when the database was originally created unless you have opted to automatically grow or shrink the database. The space allocated in the database can be determined by using the SpaceAvailable property.
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
표시: