SQL Sentry Portal Distributed Databases

Distributed SentryOne Databases

SentryOne Portal allows you to connect to distributed SentryOne databases to create a unified view across multiple SentryOne environments using a single SentryOne Portal service.

SentryOne database servers show on the sidebar menu with a (server icon) at the top of the drop-down hierarchy. In the example below there are two SentryOne database servers (SquadB-Dev and SQUADB-STABLE2.SentryOne), each representing a different monitoring environment.

SentryOne Portal Targets Distributed databases on the menu exampleDistributed databases on the menu

Implementation Example

SentryOne Portal Implementation exampleExample of a single SentryOne Portal Service pulling data from two SentryOne databases

Note:  The example above shows an EPI installation. If you are not using the EPI version, it is the same, but does not contain the EPI controller service or client bootstrapper.

Additional Information: See the SentryOne Components and Architecture article to learn more about the components in the example.

Using Distributed Databases

How are security settings used for distributed databases?

Access is at the SentryOne database level. A user must meet the security requirements as described in the SentryOne Portal User Access Requirements section of the Portal Configuration article for each SentryOne database they need to access. SentryOne Portal users will only see the SentryOne environments listed for the SentryOne database servers where they meet those security requiremnets.

Do all SentryOne databases need to be the same version?

Unsupported: SentryOne Portal does not officially support adding SentryOne databases with different versions.

SentryOne Portal does not prevent you from adding SentryOne databases that are on different versions, but you may encounter errors or unexpected issues with this setup. It is strongly recommended that all SentryOne databases are on the same version for the best experience.

Are dashboards applied across databases?

Dashboards are per SentryOne database. Any custom dashboards that you have added are at the SentryOne database level and will not appear for other SentryOne databases when using distributed databases.

How is the EHO score displayed?

The Environment Health Overview score displays for a single SentryOne database at a time. Select the SentryOne database at the top level () to view an overall EHO score for that environment.

How are the alerts displayed?

The alerts are displayed for the last SentryOne database environment that you selected.



Install SentryOne Portal on a machine that can reach all SentryOne databases that you want to add to this view. Only one SentryOne Portal service is needed per SentryOne Portal URL for multiple SentryOne databases.

Adding Distributed Databases

Distributed databases are configured in the Portal Configuration Utility (PCU). All SentryOne databases added to this SentryOne Portal service will be visible at the same SentryOne Portal URL.

  1. Open the PCU and select the Add New button.SentryOne Portal Monitor Portal Configuration Utility
  2. Enter a friendly name for the New Repository Name, then select Confirm.SentryOne Portal Add new Connection window
  3. Enter the connection information for the SentryOne database in this additional environment, then select Verify Connection. The connection information in the PCU is per database.SentryOne Portal Monitor Portal Configuration Utility Verify Connection

    Success: Your SentryOne Portal is now configured to use distributed databases. Repeat this process to add additional SentryOne databases to your view.

    SentryOne Portal Monitor Portal Configuration Utility Complete

Deleting Distributed Databases

  1. Open the PCU.
  2. Select the distributed database environment to delete from this SentryOne Portal view, then select Delete.
  3. Select Yes on the Remove Connection window to confirm that you are sure you want to remove this connection.