{"name":"Percentage of ad-hoc queries","description":"This metric displays the percentage of queries being run on the server that are ad-hoc queries.","tsql":"SELECT Convert(INT,\r\n                Sum(CASE p.objtype WHEN 'Adhoc' THEN 1 ELSE 0 END) * 1.00\r\n                \/ Count(*) * 100\r\n              )\r\n  FROM sys.dm_exec_cached_plans AS p","instances":false,"databases":{"mode":1},"frequency":60,"metricenabled":true,"noalertremark":"An alert can be set for this metric once a baseline has been established.","rateofchange":false,"aboveorbelow":"above","_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"collections":1,"alertenabled":true,"targetentitytype":0}