다음을 통해 공유

  • 아티클

GetActiveDBConnectionCount 메서드

지정한 데이터베이스의 활성 연결 수를 반환합니다.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Function GetActiveDBConnectionCount ( _
    dbName As String _
) As Integer
‘사용 방법
Dim instance As Server
Dim dbName As String
Dim returnValue As Integer

returnValue = instance.GetActiveDBConnectionCount(dbName)

public int GetActiveDBConnectionCount(
    string dbName
)

public:
int GetActiveDBConnectionCount(
    String^ dbName
)

member GetActiveDBConnectionCount : 
        dbName:string -> int 

public function GetActiveDBConnectionCount(
    dbName : String
) : int

매개 변수

반환 값

유형: System. . :: . .Int32
지정한 데이터베이스의 활성 연결 수를 지정하는 Int32 값입니다.

주의

This method returns the number of active connections to a database. By iterating through all the databases on the instance of SQL Server, you can determine the total number of connections to databases on the instance of SQL Server.

예

Visual Basic

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

'Display the number active connections to the database.
Console.WriteLine(srv.GetActiveDBConnectionCount("AdventureWorks2008R2"))

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

Write-Host $srv.GetActiveDBConnectionCount("AdventureWorks2008R2")