Today I noticed that I hadn't received any notification from CM in many hours. Upon further investigation (and testing by creating some failed logins) I concluded that the console and each monitored server's database weren't updating. Looking into if further I noticed that the Program Files\Idera\SQLcompliance\CollectionServerTraceFiles on the collection server was collecting files but apparently not loading them up. The number of files kept growing and growing. It also wasn't a case of it not keeping up with a deluge. I created a report of files grouped within the hour they were last accessed and starting about 10am yesterday things appeared to have frozen. I'm not sure what happened at 10--I don't think I added anything or changed any configuration.
I actually renamed that folder and created another one with a the old name and that one just fills up also. I've restarted services and rebooted to no avail.
Anyone ever encountered this before? Does anyone have any real world advise on the maximum number of servers I can monitor? I've got about 40 in there now and have at least 300 more to add in the coming weeks.
This sounds like some unusual behavior, we're sorry it's happening to you. Please contact our support team and they can help you to identify and diagnose the issue.
Powered by IDERA