I'm trying to restart the DPA monitoring for a SQL Instance and it looks to be hungup. The Log is showing this message:
Monitor for database [my database name] failed to start due to [max allowed monitored database sessions exceeded: 13 > 10]. Will attempt to retry every 
This SQL Instance that DPA was monitoring was restarted as an emergency last night and the DPA monitoring for this instance was not stopped. I stopped and restarted the "ignite PI Server" service thinking this might help but to no avail.
Can someone help me out here?
After conversing with DPA Support the below is what was done to resolve this issue.The reason to do the fix this way was because the 10 IgniteMonitor SPIDs were hung-up in a "KILLED/ROLLBACK" state from a previous DPA support recommendation and this production Server nor the SQL instance could not be restarted. I did upgraded to DPA 10.257 which support says will resolve the WMI issues with DPA.
As you recommended as a work around until the SQL instance and Server can be rebooted, I did uncomment and changed the statement in the “C:\Program Files\SolarWinds\DPA\iwc\tomcat\ignite_config\idc\ system.properties file from:
and the DPA monitor is back up and running for this SQL instance.
You are hitting an item that was a common issue due to some metrics that used WMI calls in older versions of DPA. Please read through this and if you have more questions open a support case.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.