.png)
PerformanceCounters Class
SQL Server 2012
A PerformanceCounters object represents a performance counter that is used to trace the performance of the instance of SQL Server.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The PerformanceCounters type exposes the following members.
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=jscript "Public property") .gif?cs-save-lang=1&cs-lang=jscript "Static member") | 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. |
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=jscript "Public method") | 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.) |
| GetHashCode | (Inherited from Object.) |
| GetType | (Inherited from Object.) |
| Reset | Resets the counter for PerformanceCounters class. |
| ToString | (Inherited from Object.) |
