This alert can be used with IgniteVM data (assuming you have the Ignite8 Performance product where alerts are defined) and will watch the VM Disk Usage Rate VMware metric. This specific example is limited to between 7:30 am and 5:00 pm (defined within the T-SQL) with the theory being that backups and other batch jobs run at night and can send the VM Disk Usage Rate up normally. This alert is designed to catch high disk usage during the day when end users are using the system. Based on the default thresholds below, it will send emails when the value exceeds 10MB / sec (10,000 KB / sec) for the most recent 10 minute timeframe.
This alert also only allows the alert to run between 7:30 am and 5:00 pm. If that is not needed you can modify or remove the "IF @TIME BETWEEN 730 AND 1700" code.
The example below uses the "vmDiskUsageRate" metric, but a very similar query can be used for other metrics as well. For a list of all metric names, you can run these queries in the Ignite repository database:
select metric_key from conv_metrics order by metric_key;
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: VM Disk Usage Rate
Execution Interval: 10 minutes
Notification Text: The following VMs are experiencing high disk usage
declare @DBID int,
-- #DBID# is passed in by the Ignite alert
set @DBID = #DBID#
-- get the current time in integer format, i.e. 7:30 am = 730 and 5:00 pm = 1700
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.
Learn more today by joining now.