Share via

  • 發行項

EnumPerformanceCounters 方法

列舉 SQL Server 執行個體所支援的效能計數器清單。

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

語法

'宣告
Public Function EnumPerformanceCounters As DataTable
'用途
Dim instance As Server
Dim returnValue As DataTable

returnValue = instance.EnumPerformanceCounters()

public DataTable EnumPerformanceCounters()

public:
DataTable^ EnumPerformanceCounters()

member EnumPerformanceCounters : unit -> DataTable 

public function EnumPerformanceCounters() : 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 物件.

範例

Visual Basic

Dim srv As Server
srv = New Server
'Call the EnumCollations method and return collation information to DataTable variable.
Dim d As DataTable
'Select the returned data into an array of DataRow.
d = srv.EnumPerformanceCounters()
'Iterate through the rows and display collation details for the instance of SQL Server.
Dim r As DataRow
Dim c As DataColumn
For Each r In d.Rows
   Console.WriteLine("============================================")
      For Each c In r.Table.Columns
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString)
   Next
Next

PowerShell

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

$d = $srv.EnumPerformanceCounters()

Foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}