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 | |
---|---|---|
PerformanceCounters | Initializes a new instance of the PerformanceCounters object. |
Top
Properties
Name | Description | |
---|---|---|
DependencyDiscoveryDuration | Gets or sets the dependency discovery duration. | |
DiscoverDependenciesDuration | Gets or sets the time period to discover dependencies. | |
DoCount | Returns Boolean value that determines whether the performance counter is enabled. | |
EnumQueriesCount | Gets or sets the number of enumerated queries in the performance counter. | |
EnumQueriesDuration | Gets or sets the time interval for the duration of the queries in the performance counter. | |
InitializeCallsCount | Gets or sets how many times the performance of the instance of SQL was called. | |
ObjectInfoRequestCount | Gets or sets the specified count of the objects in the counter. | |
SqlExecutionDuration | Gets or sets the time span value for the duration of the SQL execution in the performance counter. | |
UrnCallsCount | Gets or sets the specified number of Uniform Resource Name (URN) calls. | |
UrnSkelCallsCount | Gets or sets the specific count of Uniform Resource Name (URN) skeleton calls in the counter. | |
UrnSkeletonsPerf | Gets the current performance status of the Uniform Resource Name (URN) skeletons. | |
WalkDependenciesDuration | Gets or sets the duration of Walk Dependencies in the counter. |
Top
Methods
Name | Description | |
---|---|---|
Dump(Boolean) | Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class to a log file. | |
Dump(String) | Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class with specified file name. | |
Dump(String, Boolean) | Creates a user-mode or kernel-mode crash dump file for the PerformanceCounters class with specified file name and header. | |
Equals | (Inherited from Object.) | |
Finalize | (Inherited from Object.) | |
GetHashCode | (Inherited from Object.) | |
GetType | (Inherited from Object.) | |
MemberwiseClone | (Inherited from Object.) | |
Reset | Resets the counter for PerformanceCounters class. | |
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.