This alert is very similar to a red wait time bar on the Ignite Home page, i.e. it will warn when the wait time so far today is above it's normal behavior. For example, if it's currently 9am, this alert will determine the normal wait time as of 9am and then compare today's time against that.It will return a percentage of increase for today. If the normal wait time is 500 seconds and today has 700 seconds, the alert will return 40 (700-500/500)*100. A good threshold to set for this alert depends on how stable your wait times are, the below it uses 10-25% for a warning and over 25% for critical.
Also included below in the query, but commented out, is the concept of running this alert between 8am and 8pm, which may be more important than other timeslices. If you only want to be alerted for certain times, you can uncomment that and adjust the timeframe.
Warning: This alert has different SQL Scripts based on the Ignite Repository database platform (SQL Server vs Oracle). See below for proper script.
Available Database Instances: All database platforms are supported as this alert executes against the Ignite repository.
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert with values similar to these:
Alert Name: Abnormal Wait Time
Execution Interval: 1 Hour
Notification Text: This instance has more wait time than normal so far today.
SQL Statement: Choose the proper statement based on your Repository DB Platform
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.