SentryOne Monitor

Accelerate SQL Server performance with intuitive, online monitoring 

Are you tired of wasting valuable time trying to find the root cause of SQL Server performance problems?

SentryOne Monitor delivers powerful monitoring capabilities in a cloud solution that makes it even easier to optimize SQL Server performance. 

Actionable performance metrics—made easily accessible 

SentryOne Monitor gives you easy access to the detailed information you need to find and fix SQL Server performance problems. 

• Monitor up to 10 database targets running on your local network, on virtual machines in AWS and Azure, Azure SQL Database, Azure SQL Managed Instance, or Amazon RDS

• Receive email alerts when problems are developing in your database environment so you can take action before you have an outage

• Identify SQL queries that are dragging down SQL Server performance, and use query plans and execution histories to speed your performance tuning

• Easily share monitoring dashboards and alerts with others in your organization

Plus: Monitor Azure SQL Database with capabilities including Azure Active Directory authentication and performance dashboards that show your DTU usage

 

What you get with the SentryOne Monitor cloud solution

As a cloud solution, SentryOne Monitor gives you easily accessible, easy-to-manage tools so you can quickly gain control of your SQL Server performance. 

Easier to get up and running. Because there's less to install and configure, you can quickly start monitoring your SQL Server performance.

Less to manage.  The monitoring application runs in the cloud and is managed by SentryOne, so you only need to configure your local data collection.

Access from anywhere. SentryOne Monitor runs right in the browser. No need for a special app to view query plans or performance data. 

Frequent, easy updates. With a cloud delivery model, you'll get frequent updates, and you won't need to do any planning or coordination to install updates.

Easy to use. New features like custom dashboards and alerts make it easy to see actionable information that will help you tune your SQL Server performance. 

Questions about how our cloud solution keeps your data secure? Your data is safe with SentryOne Monitor: See the SentryOne Cloud Security section of our FAQ.

 

SentryOne Monitor FAQ

How many database targets can I monitor with SentryOne Monitor?  

SentryOne Monitor will let you monitor up to ten database targets. Support for more targets will be available in a future release.  

 

Where can my database targets be located?  

SentryOne Monitor can monitor database targets on your local network or on virtual machines in AWS and Azure. You can also monitor databases on Amazon RDS, Azure SQL DB and Azure SQL Database Managed Instance.  

 

What do I need to get up and running?  

You’ll need to install the SentryOne client application on a system with access to your database monitoring targets. The SentryOne client includes a collection service and a local SQL Server Express database that enable secure data collection from databases that are not exposed to the Internet.  

After you install the SentryOne client and configure your targets, you’ll be able to do all of your monitoring from any web browser at https://monitor.sentryone.com.  

 

What do I need to set up in the client application? 

In the client application, you'll need to add the details of the databases you want to monitor and the credentials you'll use to connect to them. SentryOne Monitor does not need you to install anything on your databases.  

 

How do I monitor my databases from the portal once I have everything configured?  

At https://monitor.sentryone.com, you'll see everything you need to monitor your databases. 

Use the Health view to see which database targets have events detected. You can click on an event to see more details and information.  

The Alerts view will show you potential issues that SentryOne Monitor has detected in your environment. You can also select Alerts for email notification.

The built-in Performance Analysis Dashboard lets you view performance data over time. It shows the most relevant metrics that our SQL Server experts recommend, including SQL Server activity, waits, and memory as well as Windows OS resource utilization. You can also create your own dashboards with customized views.  

The Top SQL view lets you see details of specific SQL queries and explore the query plans and execution histories for those queries. Top SQL helps you identify statements and tables that might benefit from tuning.  

 

What if I find something that’s not working? 

You can send feedback to the SentryOne team from right in the portal. Use the smiley face icon in the upper-right corner to open up a feedback link.  

 

What if I need help? 

Our Support team is happy to help. Please contact them if you get stuck and need assistance. 

 

What happens when my 30-day trial expires? 

Before the trial expires, you’ll receive an email inviting you to upgrade to a paid subscription. If you haven’t upgraded, SentryOne will stop collecting monitoring data at the end of the trial but will retain the data you have already collected.  

Where is my data stored?

SentryOne Cloud runs on Microsoft Azure and stores all data in a US region.

Who has access to my data?

Only SentryOne’s infrastructure engineers have access to production customer data.  This data is only accessed for troubleshooting purposes. SentryOne’s access controls follow the principle of least privilege and limit users’ access rights to the minimum level of access required to do their work.

Is my data encrypted?

All file and database storage is encrypted at rest with AES-256. All data is encrypted in transit using HTTPS. 

What data is SentryOne Monitor collecting and could it contain personal data or Personally Identifiable Information (PII)?

SentryOne collects two types of data: performance metrics and query information.

Performance metrics include things like resource utilization, reads and writes, and other SQL Server performance statistics. This data is retained for up to three years for historical analysis. Performance metrics are numeric and do not contain personal data.

Query information is used to provide in-depth analysis of performance-impacting SQL queries running in your environment. Query information is retained for only 15 days. Query information includes the full text of queries, so it may contain personal data that was included in query parameters.

For example, consider the following query:

              SELECT * FROM employees WHERE name = ‘Tom Smith’;

The query parameter “Tom Smith” is an example of personal data. SentryOne Monitor never collects the results of the query, so if there is an employee named Tom Smith then his personal data will not be collected. The query text is subject to the 15-day retention policy described above. Query information is automatically deleted at the end of the retention period.       

Most of the queries collected by SentryOne Monitor do not include personal data.

Where can I find the privacy policy for SentryOne Monitor?

SentryOne Monitor is covered by the SentryOne Privacy Policy.

Who can access my SentryOne Monitor data from the web?

As an administrative user of SentryOne Monitor, you can use the SentryOne Platform Security Portal to grant or revoke access to additional users in your organization. You can create additional administrative users or read-only users.

 

 

Comparing SentryOne Monitor with SQL Sentry

SentryOne Monitor is a cloud solution for database monitoring that builds on the power of our top-rated SQL Sentry. Here's a comparison to help you choose between SentryOne Monitor and the SQL Sentry software. 

Functionality	SentryOne Monitor	SQL Sentry
Top SQL analysis
Environmental Health Overview
Performance Analysis Dashboard
Alerts		Customizable
Maximum Databases	10	Unlimited
Deadlock analysis
Index analysis
AlwaysOn monitoring
Predictive storage capacity planning