JobServer.EnumPerformanceCounters Method (String, String, String)

Enumerates a list of SQL Server Agent performance counter information for the specified object, specified counter, and specified instance of SQL Server.

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Function EnumPerformanceCounters ( _
    objectName As String, _
    counterName As String, _
    instanceName As String _
) As DataTable
'Usage
Dim instance As JobServer 
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

Parameters

• objectName
  Type: System.String
  A String value that specifies the object for which the performance counter information is required.

• counterName
  Type: System.String
  A String value that specifies the counter name for which the performance counter information is required.

• instanceName
  Type: System.String
  A String value that specifies the instance of SQL Server.

Return Value

Type: System.Data.DataTable
A DataTable object value that contains a table of information about SQL Server Agent performance counters.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

JobServer Class

EnumPerformanceCounters Overload

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)