Share via

  • 發行項

EnumPerformanceCounters 方法 (String, String, String)

針對指定物件、指定計數器並在指定的 SQL Server 執行個體上，列舉 SQL Server 執行個體支援的效能計數器清單。

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Function EnumPerformanceCounters ( _
    objectName As String, _
    counterName As String, _
    instanceName As String _
) As DataTable
'用途
Dim instance As Server
Dim objectName As String
Dim counterName As String
Dim instanceName As String
Dim returnValue As DataTable

returnValue = instance.EnumPerformanceCounters(objectName, _
    counterName, instanceName)

public DataTable EnumPerformanceCounters(
    string objectName,
    string counterName,
    string instanceName
)

public:
DataTable^ EnumPerformanceCounters(
    String^ objectName, 
    String^ counterName, 
    String^ instanceName
)

member EnumPerformanceCounters : 
        objectName:string * 
        counterName:string * 
        instanceName:string -> DataTable 

public function EnumPerformanceCounters(
    objectName : String, 
    counterName : String, 
    instanceName : String
) : DataTable

參數

傳回值

型別：System.Data. . :: . .DataTable
DataTable 物件值，包含 SQL Server 執行個體所支援的效能計數器清單。下表將描述傳回之 DataTable 的不同資料行。

資料行

資料類型

說明

ObjectName

String

效能計數器物件的名稱。例如，SqlServer.ExecStatistics 物件。

CounterName

String

效能計數器的名稱。例如，「分散式查詢」(Distributed Query) 計數器。

InstanceName

String

要採用的度量名稱。例如，「每秒開始執行數目」(Exec started per second) 執行個體。

備註

This method enumerates all the performance counters available in SQL Server that you could use to create a performance alert. You can also see the performance counters listed in 使用 SQL Server 物件.

範例

C#

Server srv = new Server("(local)");

DataTable d = srv.EnumPerformanceCounters("SqlServer:CLR", "CLR Execution", "");
foreach (DataRow r in d.Rows)
{
   Console.WriteLine("============================================");
   foreach(DataColumn c in d.Columns)
   {
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());
   }
}

PowerShell

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

$d = $srv.EnumPerformanceCounters("SqlServer:CLR", "CLR Execution", "")
foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}