Hi!

The Performance By Utilization are blank for some servers. A server that have the same OS as Another server can work on one but not the other.

The Report named Performance By System are empty for all servers.

Please help this is a big deal for me.

I have tried to upgrade to the newest OS MP. It is scom 2012 r2.

It is also empty under monitoring-->Microsoft Windows Server-->Operating System Performance on the servers that is not showing up in the Performance By Utilization.

• Edited by Askunge Wednesday, January 21, 2015 12:47 PM more info

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

• Proposed as answer by Xin GuoMicrosoft contingent staff, Moderator Monday, February 02, 2015 7:44 AM
• Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, February 05, 2015 6:33 AM
• Unmarked as answer by Askunge 20 hours 56 minutes ago
• Unproposed as answer by Askunge 20 hours 56 minutes ago

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

• Proposed as answer by Xin GuoMicrosoft contingent staff, Moderator Monday, February 02, 2015 7:44 AM
• Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, February 05, 2015 6:33 AM
• Unmarked as answer by Askunge Thursday, February 05, 2015 2:36 PM
• Unproposed as answer by Askunge Thursday, February 05, 2015 2:36 PM

The value "MaintenanceWorkAttemptedInd" was only 1. And I still missing data.

What can I try now?

• Edited by Askunge 20 hours 54 minutes ago

The value "MaintenanceWorkAttemptedInd" was only 1. And I still missing data.

What can I try now?

• Edited by Askunge Thursday, February 05, 2015 2:38 PM