通过

  • 项目

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]
   }
}