Version 1


    This alert will watch the VM CPU Ready Time metric and alert when it exceeds the thresholds.



    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'' ' +


    EXEC (@SQL)

    Execute Against: Repository


    Units: CPU Ready Time


    High Threshold: Min 10, Max empty

    Warning Threshold: Min 5, Max 10