PerformanceCounters Class

A PerformanceCounters object represents a performance counter that is used to trace the performance of the instance of SQL Server.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.PerformanceCounters

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

Syntax

'Declaration
Public NotInheritable Class PerformanceCounters
'Usage
Dim instance As PerformanceCounters
public sealed class PerformanceCounters
public ref class PerformanceCounters sealed
[<SealedAttribute>]
type PerformanceCounters =  class end
public final class PerformanceCounters

The PerformanceCounters type exposes the following members.

Constructors

  Name Description
Public method PerformanceCounters Initializes a new instance of the PerformanceCounters object.

Top

Properties

  Name Description
Public propertyStatic member DependencyDiscoveryDuration Gets or sets the dependency discovery duration.
Public propertyStatic member DiscoverDependenciesDuration Gets or sets the time period to discover dependencies.
Public propertyStatic member DoCount Returns Boolean value that determines whether the performance counter is enabled.
Public propertyStatic member EnumQueriesCount Gets or sets the number of enumerated queries in the performance counter.
Public propertyStatic member EnumQueriesDuration Gets or sets the time interval for the duration of the queries in the performance counter.
Public propertyStatic member InitializeCallsCount Gets or sets how many times the performance of the instance of SQL was called.
Public propertyStatic member ObjectInfoRequestCount Gets or sets the specified count of the objects in the counter.
Public propertyStatic member SqlExecutionDuration Gets or sets the time span value for the duration of the SQL execution in the performance counter.
Public propertyStatic member UrnCallsCount Gets or sets the specified number of Uniform Resource Name (URN) calls.
Public propertyStatic member UrnSkelCallsCount Gets or sets the specific count of Uniform Resource Name (URN) skeleton calls in the counter.
Public propertyStatic member UrnSkeletonsPerf Gets the current performance status of the Uniform Resource Name (URN) skeletons.
Public propertyStatic member WalkDependenciesDuration Gets or sets the duration of Walk Dependencies in the counter.

Top

Methods

  Name Description
Public methodStatic member Dump(Boolean) Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class to a log file.
Public methodStatic member Dump(String) Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class with specified file name.
Public methodStatic member Dump(String, Boolean) Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class with specified file name and header.
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public methodStatic member Reset Resets the counter for PerformanceCounters class.
Public method ToString (Inherited from Object.)

Top

Remarks

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe. 

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.