Export (0) Print
Expand All

PerformanceCounters Class

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

Object
  Microsoft.SqlServer.Management.Smo.PerformanceCounters

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

'Declaration
Public NotInheritable Class PerformanceCounters
'Usage
Dim instance As PerformanceCounters

The PerformanceCounters type exposes the following members.

  NameDescription
Public methodPerformanceCountersInitializes a new instance of the PerformanceCounters object.
Top

  NameDescription
Public propertyStatic memberDependencyDiscoveryDurationGets or sets the dependency discovery duration.
Public propertyStatic memberDiscoverDependenciesDurationGets or sets the time period to discover dependencies.
Public propertyStatic memberDoCountReturns Boolean value that determines whether the performance counter is enabled.
Public propertyStatic memberEnumQueriesCountGets or sets the number of enumerated queries in the performance counter.
Public propertyStatic memberEnumQueriesDurationGets or sets the time interval for the duration of the queries in the performance counter.
Public propertyStatic memberInitializeCallsCountGets or sets how many times the performance of the instance of SQL was called.
Public propertyStatic memberObjectInfoRequestCountGets or sets the specified count of the objects in the counter.
Public propertyStatic memberSqlExecutionDurationGets or sets the time span value for the duration of the SQL execution in the performance counter.
Public propertyStatic memberUrnCallsCountGets or sets the specified number of Uniform Resource Name (URN) calls.
Public propertyStatic memberUrnSkelCallsCountGets or sets the specific count of Uniform Resource Name (URN) skeleton calls in the counter.
Public propertyStatic memberUrnSkeletonsPerfGets the current performance status of the Uniform Resource Name (URN) skeletons.
Public propertyStatic memberWalkDependenciesDurationGets or sets the duration of Walk Dependencies in the counter.
Top

  NameDescription
Public methodStatic memberDump(Boolean)Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class to a log file.
Public methodStatic memberDump(String)Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class with specified file name.
Public methodStatic memberDump(String, Boolean)Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class with specified file name and header.
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodStatic memberResetResets the counter for PerformanceCounters class.
Public methodToString (Inherited from Object.)
Top

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.  

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

Community Additions

ADD
Show:
© 2014 Microsoft