Hi It depends on 2 things: 1) How often SCOM is set to collect data. Some collection rules might be every 5 minutes but others will be at longer intervals. If these are all just for CPU then it might be worth checking the missing times against: - maintenance mode - other alerts, especially agent alerts (health service unavailable) 2) Although I don't think it is the case here, data collection on some rules is set for "optimisation" which is explained here: http://blogs.msdn.com/b/glenw/archive/2010/09/24/operations-manager-2007-optimized-performance-data-collection-collects-samples-even-when-the-current-and-last-sampled-values-are-the-same.aspx Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

We are seeing an issue where it appears that data are missing for our CPU performance counter. When we query the Data Warehouse table with the below query, we are seeing intervals where we have no data. For most, we are seeing data every 5 minutes in the table, but are seeing intervals where we may not see data for 50 minutes or so. Any idea what might be causing this? The query is being used to pull data into capacity planning software. SELECT DateAdd(hour,DateDiff(hour, getutcdate(), getDate()),[Perf].[vPerfRaw].DateTime) as DateTime, [Perf].[vPerfRaw].SampleValue, [dbo].[vManagedEntity].FullName, [dbo].[vPerformanceRuleInstance].InstanceName, [dbo].[vPerformanceRule].ObjectName, [dbo].[vPerformanceRule].CounterName FROM [Perf].[vPerfRaw] , [dbo].[vManagedEntity] , [dbo].[vPerformanceRule] , [dbo].[vPerformanceRuleInstance] WHERE DateAdd(DD, DateDiff(DD, 0, DateAdd(hour,DateDiff(hour, getutcdate(), getDate()),[Perf].[vPerfRaw].DateTime)), 0) = DateAdd(DD, DateDiff(DD, 0, GETDATE())-1, 0) and [Perf].[vPerfRaw].ManagedEntityRowId = [dbo].[vManagedEntity].ManagedEntityRowId and [dbo].[vPerformanceRuleInstance].PerformanceRuleInstanceRowId = [Perf].[vPerfRaw].PerformanceRuleInstanceRowId and [dbo].[vPerformanceRule].RuleRowId = [dbo].[vPerformanceRuleInstance].RuleRowId;

Hi It depends on 2 things: 1) How often SCOM is set to collect data. Some collection rules might be every 5 minutes but others will be at longer intervals. If these are all just for CPU then it might be worth checking the missing times against: - maintenance mode - other alerts, especially agent alerts (health service unavailable) 2) Although I don't think it is the case here, data collection on some rules is set for "optimisation" which is explained here: http://blogs.msdn.com/b/glenw/archive/2010/09/24/operations-manager-2007-optimized-performance-data-collection-collects-samples-even-when-the-current-and-last-sampled-values-are-the-same.aspx Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/