cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Alert - VM CPU Ready Time

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

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎01-10-2014 12:32 PM
Updated by: