Documentation forSQL Sentry

Monitoring Service Load Balancing

Note:  See the Installing Additional Monitoring Services section of the Installation article for step-by-step instructions on adding more monitoring services to your SQL Sentry enterprise.

Load Balancing

SQL Sentry allows for the installation of multiple monitoring services to provide automatic load balancing and fault tolerance.

SQL Sentry Navigator Monitoring Services

Note:  There's no additional configuration required to implement this functionality. 

Once an additional SQL Sentry monitoring service is installed and connected to the same SQL Sentry site during setup, they automatically distribute the monitoring load evenly between themselves, providing automatic fault tolerance and load balancing. If one SQL Sentry monitoring service fails, the remaining SQL Sentry monitoring services pick up the load automatically.

SQL Sentry Monitoring Service Load balancing diagram example one

For example, if there are three SQL Sentry monitoring services associated with six servers all contained within the same site, the SQL Sentry monitoring services divides the servers evenly among themselves, each managing two. If one SQL Sentry monitoring service fails, the other two services would pick up the unmanaged targets and divide the remaining two between themselves.

SQL Sentry Monitoring Service Load balancing diagram example two

Monitoring Services List

To view the status of all SQL Sentry monitoring services, right-click All Targets in the Navigator and select Show Monitoring Services List.

SQL Sentry Navigator Pane Show Monitoring Services List context menu option

The Monitoring Services List displays all of the monitoring services by server name. From this view, you can see the last heartbeat, account and server stats, as well as the number of monitored targets for each monitoring service. 

SQL Sentry Monitoring Services List

Note:  You can also access the Monitoring Services List by right-clicking a site node in the Navigator to view the monitoring services for only that site.