SentryOne Monitor

Powerful SQL Server performance monitoring in a cloud solution


Free Trial        Buy

 

 

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

 

Instead of having to set up client access for each team member, with SentryOne Monitor you can give them a web link, and they can go in and immediately see what’s happening with database performance

—Joseph Fleming, Senior Consultant with Straight Path Solutions

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.

 

Explore how SentryOne Monitor helps you improve SQL Server performance

Use the Health view to track high-impact events

SentryOne Monitor watches your database targets for any events that could degrade your SQL Server performance and displays those events in the Health view. You can see events by severity, use the Tag view to see impacted resources, and drill down into specific events for more details—putting you in control of your database performance.

SentryOneMonitor_HealthView
SentryOne_Monitor_Dashboard_OCT_2019

View historical database performance

The Performance Analysis Dashboard shows your overall SQL Server performance over a specified period of time:

  • SQL Server activity, waits, and memory

  • Windows OS network utilization, CPU usage, and system memory

You can use the pre-built dashboard or create custom dashboards to collect specific metrics you need to track.

Set actionable alerts

Use pre-set alerts to be notified of performance problems in your environment, by monitored target, type (such as deadlock), and severity. You can also drill into details about any alert. 

s1-cloud-monitor-eho-1
SentryOne_Monitor_TopSQL2_OCT_2019

Analyze high-impact SQL queries 

Easily identify SQL queries that are degrading your SQL Server performance with the Top SQL view. You can view query plan details and use the trace event to view each query execution. The query history gives you details including the average duration, average CPU used, and average number of reads and writes.

See SentryOne Monitor in action

Check out these video tutorials to quickly get up and running on SentryOne Monitor.

Installation and Configuration

Learn how to install SentryOne Monitor, add monitoring targets, and configure the solution for your environment.

Navigation and Health Overivew

See a quick tour of main navigation elements and learn how to use the Health Overview to identify problem areas in your environment.

Performance Analysis Dashboard

Get a quick tour of the Performance Analysis Dashboard, which displays relevant Windows and SQL Server metrics. 

Top SQL

Quickly identify and address SQL queries that are dragging down database performance with the Top SQL view.

SentryOne Monitor FAQ

How many database targets can I monitor with SentryOne Monitor?  

The preview release of 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 detectedYou 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.  

SentryOne Cloud Security

 

How does SentryOne Monitor collect and store data?

The diagram at right illustrates how SentryOne Monitor collects and stores data.

  • The SentryOne Monitor Configuration Client resides in your environment and connects to your SQL Server instances for monitoring.

  • SQL Server and Windows credentials are stored locally on the Configuration Client and never transmitted to SentryOne Monitor

  • The data that you send to SentryOne Monitor is stored in a database that is used only for your data and never for data from other customers

SentryOne_Monitor_Security_FAQ_Diagram

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 icon-checkmark icon-checkmark
Environmental Health Overview icon-checkmark icon-checkmark
Performance Analysis Dashboard icon-checkmark icon-checkmark
Alerts icon-checkmark Customizable
Maximum Databases 10 Unlimited
Deadlock analysis   icon-checkmark
Index analysis   icon-checkmark
AlwaysOn monitoring   icon-checkmark
Predictive storage capacity planning   icon-checkmark

 

SentryOne Monitor Pricing

 

SUBSCRIPTION PRICING

 

$39/month ($468 year)

 

Per monitored SQL Server instance

 

Buy

 

 

 

Subscription pricing includes annual maintenance and is based on a 12-month term paid in advance, with automatic renewal at the end of the term