Get the most complete coverage for SQL Server and Windows. Simplify performance tuning by visualizing where problems exist for faster resolution. Streamline your defragmentation process and query tuning all in one place.
We have combined all the great SQL Sentry tools into a single unified solution to help you monitor and optimize the Microsoft data platform.
Everything you need for:
SQL Server and Windows Performance Monitoring, Event Management, Index Defragmentation and Query Plan Analysis, with Desktop, Web, and Mobile UIs.
*Performance Advisor, Event Manager, Fragmentation Manager, and Plan Explorer - Learn more
The dashboard contains information from a variety of sources, all consolidated and presented in an easy to read, easy to understand visual format.
See exactly what is happening in real time, or switch to history mode and see what was happening at any time in the past.
Easily switch between Top SQL, the Event Calendar, Disk Space and more to determine exactly what was happening when you experienced problems.
Quite a bit of query traffic goes through a database server every day, and it can be difficult to tell which queries to target for optimization. Top SQL makes this easy by providing you with the highest impact queries. Sort by duration, CPU, reads, or writes depending on what resource you are troubleshooting.
Use Query Stats and Procedure Stats to identify queries that have short duration, but still impact performance by running thousands of times or more each day.
Query execution plans are captured along with the queries themselves, and integrated Plan Explorer functionality can be used to tune Top SQL queries without ever leaving the SentryOne client.
Blocking is normal for database servers, but when processes are blocked for longer than expected, application performance will suffer.
SentryOne detects long running block chains, and provides a detailed view highlighting every process that was waiting, and the process that was at the head of the blocking chain.
Quickly identify the SPID, active query, wait time, wait type, wait resource, application, host, and several other important details for blocking processes.
When processes block each other in such a way that there is no way forward a deadlock will occur, and one of the processes will fail to complete. SentryOne not only detects that this happened, but provides everything you need to decipher the complicated chain of events that lead to the deadlock.
A break-down of the processes involved is provided, complete with query text, lock mode, transaction isolation level, and other vital details.
The deadlock victim is highlighted in the deadlock diagram, and the order of operations is numbered along with lock modes for each process and resource involved in the deadlock.
Using the deadlock diagram to explain the order of events for a deadlock is as easy as 1… 2… 3.
Gain unprecedented visibility and control over scheduling issues and event conflicts that can impact server performance. Quickly view historical and future schedule information at a glance, and easily resolve conflicts using drag-and-drop.
The event history view provides flexible sorting and grouping capabilities, color-coded status indicators, and full step-level details for multi-step Agent jobs, SentryOne Index Analysis and Defragmentation, SSIS packages, SSRS reports, Top SQL events, and more.
Host system name and platform are displayed on the dashboard along with hypervisor version.
Track and take action when the host name for a monitored guest VM changes so you know when a guest VM is moved to another host while running.
View ballooned memory and CPU usage on the dashboard and quickly launch a new tab for the host.
The SentryOne patented Disk Activity view provides a graphical look into live disk system activity. You can easily identify data and log files to see where they reside on the system. For the first time, you can peer into your disk system in real time and see the hot spots!
Disk activity and disk space visualizations use a new high performance, and more manageable presentation framework allowing the ability to dynamically scale the disk space graphs.
Intelligent Alerting allows you to build alerts specific to your own monitored environment, using values and metrics retrieved from multiple sources and subsystems. Via Advisory Conditions™, you can easily create advanced performance alerting, enhanced change detection and Advisory rule sets.
Create and share your own conditions with the SentryOne community through the cloud Condition Exchange.
Access many of the same views available in the SentryOne Client including all of the popular reporting options, the new alerting Events Log, and the Global Status view. Our unique Server Health Status view provides visibility into the health of your entire environment on a single screen.
Monitor servers with little or no access to the operating system. This allows for the monitoring of SQL Server instances running on virtual machines in cloud services like Microsoft Azure or Amazon Web Services.
Find out when and how to perform defragmentation operations, when to adjust fill factors, or even when an index definition should be changed. Perform automated maintenance, view historical trends and more.
Be informed of the health status of all of your servers from a single easy to view screen. Save time by identifying poorly performing metrics on each of your servers quickly and efficiently.
Three unique layouts provide you with the ability to view your environment in a way that makes the most sense to you. Uncover performance bottlenecks and view historical performance and health details over any date range.
View blocks while they are occurring, or historically, and see all of the most important details about all of the processes involved. Kill blocking processes directly from SQL Sentry.
Get a snapshot of all of the processes and resources involved in a deadlock. Be alerted whenever a deadlock occurs. No need to install any agents, set any trace flags, or perform any configuration on monitored servers.
Advanced chaining features enable you to quickly and easily define dependencies and workflows involving SQL Agent jobs, and/or Windows tasks.
Easy to enable detailed logging for SSIS packages with a few clicks, and view the results on the SQL Sentry calendar and history list views alongside any other events on a server.
Event sources have a configurable history filter which enables control over which events are collected, displayed on the calendar, and available for alerting.
Preformatted reports are available on any metrics SQL Sentry collects, from a global level down to individual counters.
2495 List price
License option requires year one annual maintenance ($499) and provides technical support via e-mail and phone, software updates and version upgrades.
150 Per month
Subscription pricing is based on a 12-month term paid in advance with automatic renewal at the end of the term.
For more information or if you have questions about upgrading, contact sales: 704-895-6241 | 855-775-7733 toll-free | firstname.lastname@example.org
For your convenience here are links to supported browsers:
Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.