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
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.
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.
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.
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.
