Description
This alert will watch the VM CPU Ready Time metric and alert when it exceeds the thresholds.
ALERT DEFINITION
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 CPU Ready Time
Execution Interval: 10 minutes
Notification Text: The following VMs are experiencing ready time
SQL Statement:
DECLARE @VMID varchar(5), @SQL varchar(max);
-- the Ignite metric data is stored in VM specific tables, and we need the VMID to get there
SELECT @VMID=vmid FROM cond WHERE id = #DBID#;
-- query the VM metric tables for the last 10 minutes (frequency above) and calculate an average VM Disk Usage Rate
SET @SQL = 'select AVG(md.V)/1024 from CONV_METRICS m '+
'inner join CONV_METRIC_DETAIL_'+@VMID+'; md on md.METRIC_ID = m.ID '+
'where m.METRIC_KEY = ''vmReadyTime'' ' +
'and md.D >= DATEADD(MINUTE, -#FREQUENCY#, CURRENT_TIMESTAMP)'
EXEC (@SQL)
Execute Against: Repository
Units: CPU Ready Time
High Threshold: Min 10, Max empty
Warning Threshold: Min 5, Max 10
