Version 1

    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