{"name":"Table size (MB)","description":"The size in Megabytes of a specific table.","tsql":"-- Replace 'dbo.MyTable' with the name of the table you want to measure.\r\n \r\nDECLARE @SpaceUsed TABLE\r\n  (\r\n   [name] NVARCHAR(128),\r\n   [rows] CHAR(11),\r\n   [reserved] VARCHAR(18),\r\n   [data] VARCHAR(18),\r\n   [index_size] VARCHAR(18),\r\n   [unused] VARCHAR(18)\r\n  );\r\n \r\nINSERT INTO @SpaceUsed\r\n    EXEC sp_spaceused 'dbo.MyTable';\r\n \r\nSELECT (CAST(LEFT(data, LEN(data) - 3) AS BIGINT)\r\n    + CAST(LEFT(index_size, LEN(index_size) - 3) AS BIGINT)) \/ 1024.00\r\n  FROM @SpaceUsed;","instances":false,"frequency":3600,"databases":{"mode":1},"rateofchange":false,"metricenabled":true,"alertname":"Table size","alertdescription":"Raised when the size of a table exceeds a specified threshold. ","aboveorbelow":"above","collections":1,"alertenabled":true,"_thresholds_high":{"selected":true,"value":2000},"_thresholds_medium":{"selected":true,"value":1000},"_thresholds_low":{"selected":true,"value":10},"tsql_comment":"Note: Replace 'dbo.MyTable' with the name of the table you want to measure.","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}