Cloud Sync

Cloud.sentryone.com is a web service hosted by SentryOne that allows users to upload and share information about their monitored SentryOne environment. Once the cloud upload is configured, a partial replica of your on-premises SentryOne database begins syncing to the SentryOne cloud.

During the configuration process, register a user with cloud.sentryone.com, and then enable which monitored servers in your environment are synced to the cloud. Initially, only the user who completed the configuration process has access to the synced information on cloud.sentryone.com. There are several options for sharing your database outlined here, including the ability to share with individuals, and to define a subset of servers that are visible to users who share your database.  

What's Available In the Cloud?

The cloud.sentryone.com offering includes the following features:

FeatureDescription
OverviewA high level Environmental Health Overview score, just like the desktop client. The Overview displays a list of recent Advisory Conditions that have been activated across your environment.
SummaryFocus on a Site, Group, Server, or Instance to learn more about what's going on in your systems.
DashboardView the same Dashboard metrics you can find in the desktop client for any of the synced servers.
Top SQLView the Top SQL interface for each monitored SQL Server target.
ReportsRun, or schedule and email, a variety of reports on your cloud environment.
Server Health Status  A high level view of the health of your environment.
Server DetailsA detailed view of your environment's performance, including reports and an area to manage cloud sharing.
Power BIQuickly enable a SQL Sentry Power BI management dashboard. This provides you with a prebuilt set of reports and information to help you monitor and manage your server environment.


Note:  Cloud Sync utilizes standard SSL Port 443 to establish a connection. 

Configuring the Cloud in the SentryOne Client

To configure your environment for cloud synchronization, expand Configuration node in the Navigator pane (View > Navigator > Configuration) and then select the Cloud Sync node to open the cloud.sentryone.com tab.

SentryOne select Cloud Sync in the Navigator pane

Registration

From the cloud.sentryone.com tab, select Configure Sync to begin the registration process. If you have an existing SQLPerformance.com account, it can be used for cloud.sentryone.com. If you don't have an account, create one using the right side of the registration form.

SentryOne cloud.sentryone.com Configure Sync button
Select Configure Sync
SentryOne Cloud Login Existing User
Enter existing account information

SentryOne Cloud Login New User
Create a New User

Configuration

After completing the registration process and logging in, a list of all monitored targets and instances in your environment displays.

SentryOne Cloud Sync Default view

Note:  The initial state of the synchronization is Off.

SentryOne Cloud Sync Status switch

Choosing Which Targets and Instances to Sync

From the list of targets and instances in your environment, choose which ones you'd like to enable for the cloud synchronization process.

SentryOne Cloud Sync selecting targets to syncIf you'd like to select All Targets and instances, right-click and select Enable > All from the context menu.

SentryOne Cloud Sync Enable All

When an instance is selected to be synced with the cloud, Top SQL, Blocking SQL, and Deadlock information are enabled for sync by default. Disable any of these options by expanding the instance and unchecking the box next to the option(s) that you'd like to disable.

SentryOne Cloud Sync Disable Top SQL After making changes to your Sync Configuration settings, select SentryOne Save toolbar button to save your changes.

Warning: You may wish to disable Top SQL, Blocking SQL, and Deadlock information depending on the nature of the data in your database. It's possible that sensitive data can be synced from your on-premises system to the SentryOne cloud because captured plans, including the T-SQL commands executed, are included in these options.

Note:  Regardless of what sub-systems are disabled, performance metrics are always synchronized for instances that have cloud syncing enabled.

Selecting a Monitoring Service

Select a Monitoring Service for your Cloud Sync from the Monitoring Service drop-down list.

SentryOne Cloud Sync Monitoring Service drop-down list

Cloud Sync Intervals

Set the Syncing interval for your environment and the cloud.sentryone.com by selecting the Cloud Sync node in the Navigator pane.

SentryOne select Cloud Sync in the Navigator Choose your desired sync interval from the Sync Frequency drop-down list.

SentryOne Cloud Sync Frequency

Note:  The default Cloud Sync interval is one minute. The following Cloud Sync intervals are available:

  • One Minute
  • Five Minutes
  • 10 Minutes
  • 15 Minutes

Aliasing Targets, Instances, and Databases

When you synchronize your SentryOne data with the cloud you have complete control over who sees this data and how you choose to share it. As an added security feature, alias the names of targets, servers, and databases before they are synchronized. This allows you to hide potentially sensitive data.

Add aliases by typing in the Alias field.

SentryOne Cloud Sync type an alias nameAuto-generate aliases by selecting the Generate Aliases button or through the context menu.

SentryOne Cloud Sync Generate Aliases button
Generate Aliases button

SentryOne Cloud Sync Generate an alias from the context menu
Generate Alias Context menu option


Note:  Changes in alias names or objects enabled for syncing require a save before the settings takes effect.

Once you've made your selections, toggle the Off button to the On position, and after a brief initialization process, synchronization begins. Synchronization continues to occur at the Sync Frequency that's selected.

Note:  Toggling the Off Switch to On for the first time prompts the Cloud End User License Agreement. Read through the End User License Agreement, and then select Accept to continue with Synchronization.

SentryOne Cloud Sync End-User License Agreement

Once you've successfully Synced with the Cloud, the Recent Syncs screen updates with data regarding syncs to the Cloud in real-time.

SentryOne Cloud Recent Syncs

Success: The Cloud Sync Icon in the Navigator pane changes from red to green when the SentryOne Client is synced with the Cloud.


SentryOne Cloud Sync Icon Not Synced
Cloud not Synced


SentryOne Cloud Sync Icon Cloud Synced
Cloud Synced

Restricting Visibility of Servers

  • SentryOne supports restricting server visibility in the cloud through the application of Rights Based Security. With Rights Based Security, a user can be assigned a limited set of visible sites, target groups, or instances. Rights configured in the SentryOne client for a user are honored in the cloud.

  • To restrict what a shared user has access to, create a user in the SentryOne client and restrict their rights using Rights Based Security. That user then becomes available in the Link to SentryOne Client User drop-down list while sharing.

Note:  When creating a user for cloud sharing purposes, it isn't necessary for the user to have a SQL Server login.

Additional Cloud Sync Controls

ControlImage
Sync Now - Synchronize data with the Cloud immediately instead of at the scheduled time interval.SentryOne Cloud Sync Now
Enable Full Cloud Sync - Selecting this checkbox enables all data to be synced with the Cloud. Unselecting this checkbox only allows data related to Advisory Conditions to be synced with the Cloud.SentryOne Cloud Enable Full Cloud Sync
Clear Cloud Data - Removes all performance data from the Cloud, and disables sync.

Warning: Data removed from the Cloud cannot be recovered.
SentryOne Cloud Clear Cloud Data
Include Logins and Host names - Selecting this checkbox disables By User and By Server reports on the Cloud. SentryOne Cloud Include Logins and Host names

Context Menu Options

OptionImage
Collapse All- Collapse all expanded target configuration grids.SentryOne Cloud Collapse All context menu option
Expand All- Expand all target configuration grids.SentryOne Cloud Expand All context menu option
Enable > All - Fully enable all sync options for all targets.

Enable > All for Target - Enable all sync options for the selected target.
SentryOne Cloud Enable All context menu options
Disable > All - Fully disable all sync options for all targets.

Disable > All for Target - Disable all sync options for the selected target.
SentryOne Cloud Disable All context menu options
Alias > Generate - Generate an alias for the selected target.

Alias > Clear - Remove the alias for the selected target.
SentryOne Cloud Alias context menu options