通过

  • 项目

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