SDKPerformanceView
SDKPerformanceView is a SQL view that stores performance counter data from the computers managed by MOM.
The standard syntax for specifying performance counter paths is as follows.
\\Computer\PerfObject(ParentInstance/ObjectInstance#InstanceIndex)\Counter
For more information about the naming conventions and concepts used with performance counters, performance objects, and performance object instances, see Performance Objects and Counters in the Windows SDK.
The following table describes the columns of this view.
| Column | SQL Server type | Null values allowed? | Description |
|---|---|---|---|
ComputerDNSName |
nvarchar(512) |
Yes |
If applicable, the DNS name of the computer. |
ComputerName |
nvarchar(255) |
No |
The name of the computer. |
PerformanceInstanceName |
nvarchar(255) |
Yes |
The name of the instance of the performance counter object. Instance information is necessary only when more than one copy of the performance object exists. |
PerformanceObjectName |
nvarchar(255) |
No |
The name of the performance object. |
PerformanceCounterName |
nvarchar(255) |
No |
The name of the performance counter. |
ScaleFactor |
float |
No |
The amount to scale the value of the counter. Scaling is useful when graphing counters with different value ranges or even different units of measurement along a single axis. |
LegendFactor |
nvarchar(10) |
No |
The name assigned to the performance counter in a graph. |
TimeSampled |
datetime |
No |
The time when the performance counter value was sampled. |
SampledValue |
float |
No |
The value of the performance counter. Units of measurement depend on the performance counter. |
Examples
The following example shows how to query SDKPerformanceView for the name of all computers that have experienced periods of processor use that exceeded 80 percent.
SELECT SDKPerformanceView.ComputerName
FROM SDKPerformanceView
WHERE SDKPerformanceView.PerformanceObjectName = 'Processor'
AND SDKPerformanceView.PerformanceInstanceName = '_Total'
AND SDKPerformanceView.PerformanceCounterName = '% User Time'
AND SDKPerformanceView.SampledValue > 80
Requirements
Platforms: Requires Windows 2000 Server or later
Version: Requires MOM 2000 SP1 or later
Database: OnePoint (MOM 2000 SP1 or later) or SystemCenterReporting (MOM 2004 or later)