About SQL Sentry

Breakthrough SQL Server performance monitoring.

SQL Sentry is a monitoring and observability product. It was built by Microsoft SQL Server experts to help you save time and frustration when troubleshooting database performance problems. SQL Sentry provides continuous performance monitoring that is the cornerstone of a collaborative Intelligent DataOps process. It offers powerful capabilities in an intuitive dashboard that gives you an at-a-glance picture of your SQL Server environment health, and makes it easy to drill down for more details.

  • View detailed performance metrics
    • Performance Analysis Dashboard - See actionable performance information about your monitored servers in an easy-to-use Performance Analysis Dashboard that displays a graphical view of monitored server activity with "Jump To" navigation that lets you drill down to granular details.
  • Fix high-impact SQL queries
    • Top SQL - Frustrated by the time and effort it takes to identify SQL Server queries and procedures that are causing performance bottlenecks? The Top SQL view in SQL Sentry shows execution plan diagrams, query history, and more, so you can find and fix potentially problematic queries. The query analysis capabilities in SQL Sentry go far beyond what you'll find in SQL Server Management Studio (SSMS), giving you the information you need to quickly resolve problems.
  • Set automated responses to specific conditions
    • Advisory Conditions - Proactively manage database performance and eliminate alert fatigue with Advisory Conditions that let you set relevant, actionable alerts based on conditions specific to your environment. With Advisory Conditions, you can automate responses to specific conditions, such as the results of a T-SQL query, a WMI query, a performance counter value, or any combination of values or queries.
  • Access performance data from a web browser
    • The SentryOne Portal - With the SentryOne Portal, you can view important performance data for your monitored SQL Server, Azure SQL Database, and Windows targets in an easy-to-use web interface. The SentryOne Portal connects to your existing SentryOne database and includes core SQL Sentry capabilities, such as the Performance Analysis Dashboard, Top SQL, Environment Health Overview, and blocking and deadlocks analysis.

Other Features

  • SQL Server and Windows processes
  • Environment Health Overview
  • Integrated Plan Explorer
  • Blocking SQL view
  • Deadlocks view
  • Alerting
  • TempDB analysis
  • Index analysis and management
  • Event Calendar and event management
  • Event history retention
  • Disk Activity view and standard disk forecasting
  • Advanced disk forecasting optimized with ML
  • Scalability Pack
  • Always On Availability Group monitoring
  • Event Chain creation and management

What you can monitor:

  • SQL Server
  • Azure SQL Database (dedicated licenses available)
  • SQL Server Analysis Services (SSAS)
  • SQL Server on Hyper-V or VMware VMs (including host)
  • SQL Server on Azure SQL Database Managed Instance
  • SQL Server on Amazon RDS
  • SQL Server on Amazon EC2
  • SQL Server on Linux