{"name":"Total database file size","description":"This custom metric measures the total database file size (data files and log file combined).","tsql":"SELECT    SUM(size) * 8.0 \/ 1024.0 \/ 1024.0 AS SizeInGB\r\nFROM    sys.database_files;","instances":true,"databases":{"mode":1},"frequency":1800,"metricenabled":true,"alertname":"Database size increase","alertdescription":"This alert is raised when the total size of the database files has increased. When not done by the DBA, this is an autogrow.\r\nExcessive autogrow events should be prevented as this can result to file fragmentation. Try to manually grow files before autogrow kicks in. If despite active file size management this metric detects a change, a database is probably growing at an unexpected rate.","_thresholds_high":{"selected":true,"value":25},"_thresholds_medium":{"selected":true,"value":10},"_thresholds_low":{"selected":true,"value":0},"aboveorbelow":"above","rateofchange":true,"alertenabled":true,"frequency_comment":"seconds (collected every 30 minutes","collections":1,"targetentitytype":0}