{"name":"Number of active backups and restores","description":"Calculates the total number of \"BACKUP DATABASE\" and \"RESTORE DATABASE\" commands that are currently being run.","tsql":"SELECT count (r.command)\r\n\r\nFROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a WHERE r.command in ('BACKUP DATABASE','RESTORE DATABASE')","instances":false,"databases":{"mode":1},"frequency":60,"metricenabled":true,"noalertremark":"This metric is most useful for comparing against others to find any correlation, and so an alert will not generally be useful.","rateofchange":false,"aboveorbelow":"above","_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"collections":1,"alertenabled":true,"targetentitytype":0}