Are you using the exchange 2010 MP? Remember load on the DB is created by your management packs.Microsoft Corporation

This looks like a State View query to me. Can you see what State Views your Console users have open? Also, how many rows does this query return? Have you tried using the SQL Activity Monitor or sp_who2 to see if there's any blockign going on? I suspect if a query like this is occuring that there are MP's being imported at this time, or that there's a complex group calculation rule that's running.Michael Pearson OpsMgr Performance Test Team http://blogs.technet.com/michaelpearson/ This posting is provided "AS IS" with no warranties, and confers no rights. Use of attachments are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm

One thing to check is your role scoping. I had my scoping in place that was a little "dynamic", which was hammering our ops DB when a new user opened a console. When I simplified my role views, SQL got a little bit better. So scoping, for users, is very important for SQL health (Less is more).Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/

We are having big issues with high CPU usage on our server hosting the Operations DB. The total CPU is constantly at above 60% and averaging around 75%. The server is highly spec'd with 4 CPU's and 32gig of RAM. I have run a SQL trace and queries just like one below are taking around an hour to complete and 2 or 3 are running at all times. For a brief period today none of these queries were running and the CPU hovered at around 20%. The ApplicationName according to SQL trace is MOM DAL--MOM SDK. The @ManagedTypeIdForManagedEntitiesByManagedTypeAndDerived parameter in the query is always pointing to the System.Entity id. I cant seem to find any dynamic groups where the MonitoringClass is System.Entity. Any ideas what this might be? Thanks exec sp_executesql N'-- MonitoringObjectsByCriteria <ManagedTypeIdForManagedEntitiesByManagedTypeAndDerived> SELECT [ManagedEntityGenericView].[Id], [ManagedEntityGenericView].[Name], [ManagedEntityGenericView].[Path], [ManagedEntityGenericView].[FullName], [ManagedEntityGenericView].[DisplayName], [ManagedEntityGenericView].[IsManaged], [ManagedEntityGenericView].[IsDeleted], [ManagedEntityGenericView].[LastModified], [ManagedEntityGenericView].[TypedManagedEntityId], [ManagedEntityGenericView].[MonitoringClassId], [ManagedEntityGenericView].[TypedMonitoringObjectIsDeleted], [ManagedEntityGenericView].[HealthState], [ManagedEntityGenericView].[StateLastModified], [ManagedEntityGenericView].[IsAvailable], [ManagedEntityGenericView].[AvailabilityLastModified], [ManagedEntityGenericView].[InMaintenanceMode], [ManagedEntityGenericView].[MaintenanceModeLastModified], NULL AS SourceEntityId FROM dbo.ManagedEntityGenericView INNER JOIN ( SELECT DISTINCT [BaseManagedEntityId] FROM dbo.[TypedManagedEntity] TME WITH(NOLOCK) JOIN [dbo].[DerivedManagedTypes] DT ON DT.[DerivedTypeId] = TME.[ManagedTypeId] WHERE DT.[BaseTypeId] = @ManagedTypeIdForManagedEntitiesByManagedTypeAndDerived AND TME.IsDeleted = 0 ) AS ManagedTypeIdForManagedEntitiesByManagedTypeAndDerived ON ManagedTypeIdForManagedEntitiesByManagedTypeAndDerived.[BaseManagedEntityId] = [Id] WHERE (([IsDeleted] = 0 AND [TypedMonitoringObjectIsDeleted] = 0))',N'@ManagedTypeIdForManagedEntitiesByManagedTypeAndDerived uniqueidentifier',@ManagedTypeIdForManagedEntitiesByManagedTypeAndDerived='<System.EntityIDGoesHere>'