{"name":"Query execution reuse","description":"The percentage of query executions that have been able to reuse cached query plans.","tsql":"SELECT Sum(CASE WHEN deqs.execution_count > 1 THEN deqs.execution_count ELSE 0 END)\r\n       * 1.00 \/ Sum(deqs.execution_count) * 100\r\n  FROM sys.dm_exec_query_stats AS deqs","instances":false,"databases":{"mode":1},"frequency":60,"noalertremark":"An alert for this metric can be created after establishing a baseline.","metricenabled":true,"rateofchange":false,"aboveorbelow":"above","_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"collections":1,"alertenabled":true,"targetentitytype":0}