Advisory Conditions: Intelligent Alerts for SQL Server Performance Problems

What are SentryOne Advisory Conditions?

SentryOne Advisory Conditions are a proactive alerting and response system that helps you customize notifications based on parameters that are specific to your environment. By using pre-built or customer Advisory Conditions, you can anticipate and prevent database performance problems.

You'll find this feature in:

SQL Sentry | Win Sentry

Managing a complex SQL Server environment is challenging

 

Being responsible for SQL Server performance and health can be a daunting task.

As a DBA, you’re expected to be aware of everything that’s happening in your SQL Server environment at all times. But to do that, you need the right information at the right time.

You need the ability to set up alerts that notify you when your environment experiences peak user traffic or when specific key SQL queries are running too slow. You need to know when one of the Windows servers shows high CPU usage.

And wouldn’t it be great if you could set up and automatically fire off a database action—or a set of actions, such as a stored procedure—that can remedy the situation when a certain performance threshold condition is reached.   

You need actionable information—not a storm of alerts that are mostly noise, masking the real problem you need to solve.

If you need a powerful, flexible solution for proactively monitoring your environment across a diverse range of situations, take a look at SentryOne Advisory Conditions.

Advisory Conditions Interface Screenshot

 

SentryOne Advisory Conditions can be configured for any SentryOne monitored target, including SQL Server, Azure SQL Database, SQL Server Analysis Services (SSAS), Windows, and VMware hosts.

 

Advanced alerting and response capabilities for your SQL Server environment

 

Define Advisory Conditions

 

You can define SentryOne Advisory Conditions using logical operators.

SentryOne Advisory Conditions form an advanced alerting and response system that allows you to truly customize the SentryOne Monitoring products to respond to any Windows, virtual machine (VM), or SQL Server database condition with complex logic based on performance counter thresholds, query results, and more.

For example, Advisory Conditions allow you to collect and compare the results of a T-SQL query or WMI query. They also help you automate responses (actions), including sending notifications and executing commands on items specific to your environment and the applications that you support.

The SentryOne Monitoring products ship with pre-built Advisory Conditions, which you can configure for your environment. Conditions can be set up at different levels of inheritance within your monitored environment.

You can view the list of Advisory Conditions that are available to you, create a new condition, edit an existing condition, and view the condition events log, which gives you information when the condition was last evaluated for “True,” and more.

 

Advisory Conditions Feature Summary

  • Advanced alerting and response system for your entire database environment
  • Choose from more than 100 pre-built conditions available for Microsoft Windows, SQL Server, SSAS, APS, and more
  • Allows you to define conditions that collect and compare the results of a T-SQL query, WMI query, Performance Counter value, or combination of values and queries
  • Responses include apparent things like notifications, but can also be used for logging, executing commands, starting jobs, and a host of other actions

“Custom conditions are an excellent addition to the product.”

—Chris Taylor, Director, Jarrin Consultancy Ltd.

 

Read more independent SentryOne reviews on TrustRadius.