No Windows Server Performance data - SCOM 2012 R2

There is no (apart from a few % data) performance data being presented in the scom 2012 R2 > Microsoft Windows Server > Performance view. (See attached)

Is this another bug or something is broken?
Most of my fleet is 2012R2 and a few 2008R2.

Any assistance will be appreciated.

Performance-1.png

Hi

Not all of the performance counters are enabled by default:

You might also want to check overrides to see any of the data collection has been disabled.

Cheers

Graham

2 Likes

Hi,

 

agree to Graham, check the rules first. - I made the mistake when I did ‘management - tuning’ that I created overrides for too many performance rules. - So take a look on the overrides, too :wink:

Besides, check if the SCOM Databases still have sufficient free space and reboot the management servers one by one (if you have 2).

 

If all not works. - Last, you can also check if the Operations Manager DW is too busy and is not able to do aggregations. - Use the following script ( without warranty ) to check outstanding data aggregations.

USE OperationsManagerDW;

WITH AggregationInfo AS (
	SELECT 
	AggregationType = CASE 
		WHEN AggregationTypeId = 0 THEN 'Raw'
		WHEN AggregationTypeId = 20 THEN 'Hourly'
		WHEN AggregationTypeId = 30 THEN 'Daily'
		ELSE NULL
	END
	,AggregationTypeId
	,MIN(AggregationDateTime) as 'TimeUTC_NextToAggregate'
	,COUNT(AggregationDateTime) as 'Count_OutstandingAggregations'
	,DatasetId	FROM StandardDatasetAggregationHistory
	WHERE LastAggregationDurationSeconds IS NULL
	GROUP BY DatasetId, AggregationTypeId
)

SELECT
SDS.SchemaName
,AI.AggregationType
,AI.TimeUTC_NextToAggregate
,Count_OutstandingAggregations
,SDA.MaxDataAgeDays
,SDA.LastGroomingDateTime
,SDS.DebugLevel
,AI.DataSetId

FROM StandardDataSet AS SDS WITH(NOLOCK)
JOIN AggregationInfo AS AI WITH(NOLOCK) ON SDS.DatasetId = AI.DatasetId 
JOIN dbo.StandardDatasetAggregation AS SDA WITH(NOLOCK) ON SDA.DatasetId = SDS.DatasetId AND SDA.AggregationTypeID = AI.AggregationTypeID
ORDER BY SchemaName DESC

Let me know the results

1 Like