Monitored Instances dropping off Dashboard over time?

KayD

Hi,

Does anyone else have this issue where after a couple of months, the list of monitored servers appears to slowly decrease on the SQL Monitor Dashboard? It looks like the instances just start dropping off the list.

The workaround we've been using is restarting the SQL Base Monitor Service. Everything appears to be back to normal after that.

Any advice to fix this would be appreciated.

Regards,

KD

Russell D

What version of SQL Monitor are you using? We did have a bug in an older version where this happened occasionally, but it was fixed quite a while ago.

In addition to this anything that might help recreate the issue apart from just leaving the base monitor running for a while would be of great help. It's hard to recreate that sort of issue. After what length of time are you seeing MEs drop off the dashboard?

KayD

Hi Russell,

We're currently on version 7.1.1. It is noticeable after about 6-8 weeks that the servers have started disappearing. Apart from that, I haven't seen anything unusual, or rather I'm not sure what to look for.

Russell D

Ok 6-8 weeks could be hard to recreate. Are you seeing large memory usage in WMI at all? A potential memory leak that restarting the basemonitor resolves temporarily? I guess we can only really ask that next time it happens, before restarting the basemonitor send in your logs and information on system resources and the like and we can try and take a look before it gets wiped.