1) go to monitoring workspace--> Micosoft Windows Server --> operating System Performance
2) Check whether the performance data is successful capture in operation manager. If not, go to Operations Manaer --> Agent Details --> Agent Health State --> Flsh Health Service State and Cache of problematic agent
3) Check any HealthService 2115 events is logged on the ManagementServer. If 2115 error is logged, this means that Management servers are unable to insert data into the OperationsManagerDW database. You can refer to
http://support.microsoft.com/kb/945946
4) Check Operations Manager event log for event ID 31552 with the following workflow name listed in the event description:
Microsoft.SystemCenter.DataWarehouse.StandardDataSetMaintenance
This means that Data is stuck in the staging tables in the OperationsManagerDW database.
run maintenance manually
Declare @DataSet uniqueidentifier
Set @DataSet = (Select DataSetId From StandardDataset Where SchemaName = 'Perf')
Exec StandardDataSetMaintenance @DataSet
Continue running the above until you only have 1-3 entries (this is normal, 1 entry for each aggregation type). If you see A LOT of entries (More than 100) you may want to run the below:
Declare @i int
Set @i=0
Declare @DataSet uniqueidentifier
Set @DataSet = (Select DataSetId From StandardDataset Where SchemaName = 'Perf')
While(@i<=500)
Begin
Exec StandardDataSetMaintenance @DataSet
Set @i=@i+1
Waitfor Delay '00:00:05'
End
Roger