Database Reference
In-Depth Information
Perf.vPerfRaw
The
Perf.vPerfRaw
view contains the raw performance data without aggregates.
Using this view is helpful when you want to create custom aggregates in your perform-
ance reports. This view can also be joined to the
vManagedEntity
and
vPerform-
anceRuleInstance
views to retrieve information on the counters, rules, and mon-
itored objects.
The following query returns monthly aggregates of performance data. It also includes ad-
ditional columns for other aggregate functions, such as standard deviation for the popula-
tion for all values and variance:
SELECT
CONVERT(varchar(7), P.DateTime, 126) AS MonthlyAggregate,
P.ManagedEntityRowId,
P.PerformanceRuleInstanceRowId,
COUNT(P.SampleValue) AS SampleCount,
MIN(P.SampleValue) AS MinValue,
MAX(P.SampleValue) AS MaxValue,
AVG(P.SampleValue) AS AverageValue,
STDEV(P.SampleValue) AS StandardDeviation,
VAR(P.SampleValue) AS Variance,
STDEVP(P.SampleValue) AS StandardDeviationPopulation,
VARP(P.SampleValue) AS VariancePopulation
FROM
Perf.vPerfRaw P
GROUP BY
CONVERT(varchar(7), P.DateTime, 126),
P.ManagedEntityRowId,
P.PerformanceRuleInstanceRowId
The following screenshot shows a graphical view of the joins discussed in this section:
