{"name":"Rate of change of database file size in MB\/hour","description":"Monitors the rate of change of the database file size. ","tsql":"SELECT cntr_value\r\n  FROM sys.dm_os_performance_counters\r\n  WHERE [instance_name] = DB_NAME()\r\n    AND object_name = CASE WHEN SERVERPROPERTY('InstanceName') IS NULL\r\n                           THEN 'SQLServer'\r\n                           ELSE 'MSSQL$'\r\n                                + CAST(SERVERPROPERTY('InstanceName') AS VARCHAR)\r\n                      END + ':Databases'\r\n    AND [counter_name] = 'Data File(s) Size (KB)';\r\n","instances":false,"frequency":1800,"databases":{"mode":1},"rateofchange":true,"metricenabled":true,"alertname":"Database file size increased","alertdescription":"Raised when an increase in the database file size is detected. Automatic size increases to accommodate new data can quickly lead to highly fragmented databases and poor query performance. To avoid automatic increases, a database's maximum file size should be estimated in advance, and sufficient storage capacity should be allocated accordingly. ","aboveorbelow":"above","collections":1,"alertenabled":true,"_thresholds_high":{"selected":true,"value":100},"_thresholds_medium":{"selected":true,"value":10},"_thresholds_low":{"selected":true,"value":1},"thresholds_comment":"Note: These thresholds are intended as guideline values. If they seem too high or too low for your environment, replace them with values more suited to your server performance.","targetentitytype":0}