Advisory Conditions: Intelligent Alerts for SQL Server Performance Problems

What are SQL Sentry Advisory Conditions?

SolarWinds 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 custom Advisory Conditions, you can anticipate and prevent database performance problems.

You'll find this feature in:

SolarWinds SQL 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 SQL Sentry Advisory Conditions.



SQL Sentry Advisory Conditions can be configured for any SQL Sentry 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 SQL Sentry Advisory Conditions using logical operators.

SQL Sentry Advisory Conditions form an advanced alerting and response system that allows you to truly customize the SQL Sentry 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 SQL Sentry 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 SQL Sentry reviews on TrustRadius.

Ready to end your database performance problems?


Download a SQL Sentry trial

See for yourself how SQL Sentry can help you achieve optimal database performance.

Download Free Trial

Schedule a SQL Sentry demo

Learn more about how SQL Sentry can help you troubleshoot and prevent database performance problems. Register to attend a public demo or schedule a one-on-one session.

Schedule Demo

Learn more about SQL Sentry

Discover how you can quickly find and fix SQL Server performance problems with SQL Sentry, which delivers proven scalability, easy-access dashboards, and visibility across your entire database environment.

Learn More