Are you tired of wasting valuable time trying to find the root cause of SQL Server performance problems?
SentryOne Monitor—now available for preview—delivers powerful monitoring capabilities in a cloud solution that builds on our top-rated flagship product, SQL Sentry.
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, or on Azure SQL Database Managed Instance
Identify events that are degrading performance with the environment health tools
Use the Top SQL view to identify SQL queries that are dragging down SQL Server performance, and use query plans and execution histories to speed your performance tuning
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 database runs in the cloud and is managed by SentryOne, so you can focus on optimizing performance.
Access from anywhere. With our Universal Client, the only component you need to install on your local workstation is a 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 the custom dashboards make it easy to see actionable information that will help you tune your SQL Server performance.
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.
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.
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.
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.
SentryOne Monitor can monitor database targets on your local network or on virtual machines in AWS and Azure. You can also monitor databases on Azure SQL Database Managed Instance.
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 with our Universal Client portal at https://monitor.sentryone.com.
In the client application, you'll need to do a few setup tasks to get everything ready to go:
Add database targets—do this first so that you can start collecting data.
Set up conditions and alerts—this is where you configure email notifications and automated responses to events detected by the monitoring system. If you don’t set these, you’ll still see events on the Health page of the Universal Client portal.
Adjust settings for data collection and monitoring—most users will be fine with the default values, but there’s a lot of flexibility here if you need it.
At https://monitor.sentryone.com, you'll see three key monitoring views: Health, Dashboard, and Top SQL.
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 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.
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.
Our Support team is happy to help. Please contact them if you get stuck and need assistance.
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.
Subscription pricing is based on a 12-month term paid in advance with automatic renewal at the end of the term