The number of monitored servers (WIN +SQL) between Spotlight servers on a federated environment is approximately equally but the database load among the Spotlight servers is not evenly distributed.
Is there a way to prevent and/or fix this with Spotlight?
WORKAROUND
Having the same amount of connections in both DS does not guarantee same load and/or size of database as the load among the Spotlight servers is not evenly distributed.
Also, there is not any way to know this beforehand (with SoSSE) and it is necessary to adjust this "manually" if the load is very different.
STATUS
Enhancement request number SOSSE-I-104 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center