Currently when I take SQLDM out of Maintenance mode the CPU utilization o the OLTP database it is monitoring goes up to between 75 and 95% and stays there for over 12 hours.
We are running SQL Server 2012 enterprise and SQLDM version 10.0.0.2127
Is there a standard configuration we should be looking at for Alerts and Monitoring
Thanks in Advance!
Check if you have Query Monitor enabled. If so, check if you are collecting Query Plans. If so, uncheck the box to collect Query Plans, either actual or estimated Query Plans.
May check also with the query:
SELECT InstanceName, QueryMonitorEnabled, QueryMonitorCollectQueryPlan, QueryMonitorCollectEstimatedQueryPlanFROM dbo.MonitoredSQLServers WHERE Active= 1AND QueryMonitorEnabled = 1
May this could be the Problem, but you have to check it out.