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.
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
"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."
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.
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 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.
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.
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.
Check out these video tutorials to quickly get up and running on SentryOne Monitor.
Learn how to install SentryOne Monitor, add monitoring targets, and configure the solution for your environment.
See a quick tour of main navigation elements and learn how to use the Health Overview to identify problem areas in your environment.
Get a quick tour of the Performance Analysis Dashboard, which displays relevant Windows and SQL Server metrics.
Quickly identify and address SQL queries that are dragging down database performance with the Top SQL view.
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 Amazon RDS, Azure SQL DB and 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 at https://monitor.sentryone.com.
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.
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.
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.
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 Cloud runs on Microsoft Azure and stores all data in a US region.
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.
All file and database storage is encrypted at rest with AES-256. All data is encrypted in transit using HTTPS.
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.
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.
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.
|Top SQL analysis|
|Environmental Health Overview|
|Performance Analysis Dashboard|
|Predictive storage capacity planning|