Im hoping someone can help direct me to the cause of a Single Agent and one of its monitoringhost.exe processes using upwards of 20% CPU Consistently.
I have a single host that is 1 of 4 SQL Cluster Hosts so this host has multiple virtualised SQL Cluster instances running on it as do the other 3 hosts but one in particular has a monitoringHost.exe process that is consistently using High CPU for the past 3 weeks.
This host is a member of the same groups as the other 3 hosts so has the same number of rules and monitors directed at it as the other 3 Hosts
agent cache has been cleared , i also reinstalled the agent and the problem returns.
the event log shows no irregularities aside from some 1207 errors for non remotable rules, which are consistent across the other 4 hosts
I have noticed on the host that it is writing 50000 plus errors every 10 minutes to the application event log , i am not collecting these errors but would i be correct in thinking the agent is having to follow that event log and thus working hard to do so ?