SQL Server Table Sizes

If you want to alert on table sizes, the attached script will retrieve a list of tables with its associated size in GB for all non-system database in the instance. This script can be plugged into a Custom - Multiple Numeric alert in DPA.

For example, if you want to get a Warning alert when a table grows to above 850GB and a Critical alert, setup an alert with thresholds similar to this: