Important: The SentryOne Cloud Sync feature is being removed in Q1 of 2020. As a result, all Cloud Sync databases will be deleted from the cloud.
In January 2020, we're replacing Cloud Sync with a more robust browser-based portal which shares the UI experience of the SentryOne Monitor solution. If you're a current Cloud Sync user, we encourage you to check out the SentryOne Portal design through the SentryOne Monitor documentation.
In the meantime, if you have any questions or concerns, or if you'd like to check out the SentryOne Portal now, please contact our support team at support.sentryone.com.
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:
|Overview||A 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.|
|Summary||Focus on a Site, Group, Server, or Instance to learn more about what's going on in your systems.|
|Dashboard||View the same Dashboard metrics you can find in the desktop client for any of the synced servers.|
|Top SQL||View the Top SQL interface for each monitored SQL Server target.|
|Reports||Run, 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 Details||A detailed view of your environment's performance, including reports and an area to manage cloud sharing.|
|Power BI||Quickly 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.|
- Cloud Sync supports SQL Server and Windows targets only.
- Cloud Sync utilizes standard SSL Port 443 to establish a connection.
- Tables have a data capacity limit of 5 GB or 5 million rows for Cloud Sync. If your table exceeds this limit, it will not be able to sync and you may see an error message indicating that the table is too large.
Configuring the Cloud in the SentryOne Client
To configure your environment for cloud synchronization, expand the Configuration node in the Navigator pane (View > Navigator > Configuration) and then select the Cloud Sync node to open the cloud.sentryone.com tab.
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.
Note: Cloud Sync does not support authenticating via LDAP (Lightweight Directory Access Protocol).
After completing the registration process and logging in, a list of all monitored targets and instances in your environment displays.
Note: The initial state of the synchronization is Off.
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.
If you'd like to select All Targets and instances, right-click and select Enable > All from the context menu.
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.
After making changes to your Sync Configuration settings, select 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.
Additional Information: See the SentryOne Cloud Sync and GDPR blog post for details on ensuring GDPR (General Data Protection Regulation) compliance with Cloud Sync. This also applies to PCI Compliance. The SentryOne application isn't processing its own credit card data; however, you can disable the sync of Top SQL, Blocking SQL, and Deadlock information to eliminate the chance that any PCI data would be inadvertently synced through query parameter values.
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.
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.
Choose your desired sync interval from the Sync Frequency drop-down list.
Note: The default Cloud Sync interval is one minute. The following Cloud Sync intervals are available:
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.
Auto-generate aliases by selecting the Generate Aliases button or through the context menu.
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.
Once you've successfully Synced with the Cloud, the Recent Syncs screen updates with data regarding syncs to the Cloud in real-time.
Success: The Cloud Sync Icon in the Navigator pane changes from red to green when the SentryOne Client is synced with the Cloud.
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 for a user in the SentryOne client 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
|Sync Now - Synchronize data with the Cloud immediately instead of at the scheduled time interval.|
|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.|
|Clear Cloud Data - Removes all performance data from the Cloud, and disables sync.|
Warning:Data removed from the Cloud cannot be recovered.
|Include Logins and Host names - Selecting this checkbox disables By User and By Server reports on the Cloud.|
Context Menu Options
|Collapse All- Collapse all expanded target configuration grids.|
|Expand All- Expand all target configuration grids.|
|Enable > All - Fully enable all sync options for all targets.|
Enable > All for Target - Enable all sync options for the selected target.
|Disable > All - Fully disable all sync options for all targets.|
Disable > All for Target - Disable all sync options for the selected target.
|Alias > Generate - Generate an alias for the selected target.|
Alias > Clear - Remove the alias for the selected target.