Description

This alert will calculate the average procedure cache hit ratio in Ignite 8 based on the most recent 10 minutes of data (governed by the frequency of execution, e.g. once every 10 minutes in this case).

SQL Statement

select ISNULL(AVG(md.V*1.0),-1) avg_pchr
from CON_METRICS_NAMES_#DBID# mn
inner join CON_METRICS_#DBID# m on m.METRIC_NAME_ID = mn.ID
inner join CON_METRICS_DETAIL_#DBID# md on m.ID = md.METRICS_ID
where mn.NAME = 'Procedure Cache Hit Ratio'
and md.D >= DATEADD(MI, -#FREQUENCY#, current_timestamp)

Alert Definition