I have 15 Spectrum instances feeding a single MLS for consolidated view of the enterprise network monitoring.
At Version 9.4.2 I was told by support that the problem would be fixed in release 10.2 so I waited.
The problem DID seem to be related to Juniper devices because only 3 of 15 locations were experiencing the memory leak, and those 3 locations had the most Juniper devices.
However, Now that we have 10.2 installed for over 2 months, we still continue to have the same symptoms, but support is saying the leak is with "hos / workstation" models, or Cisco ASA models.
We still have 3 centers that crash about once per month ( more or less ).
We created a "self heal" script that does a stopSS.pl - wait 10 minutes - startSS.pl. This allows Spectrum to fail over and fail back which is painful, but not nearly as painful as rebuilding the database from a hard crash.
If anyone figures this out, please let me know. So far, Spectrum developers and engineers have not been able to pin-point the problem.