The SQL Server Tablespace Check monitor connects directly to the database instance and runs the following set of commands to verify tablespace usage:

sp_helpdb;

  • Uses the name field to find more information about each database served by the instance.

sp_helpdb $name;

  • Parses the sp_help output to determine overall datafile size for the database.  The size and maxsize fields are totalled to determine the overall datafile size and usage for the given database.

A warning or critical outage will be registered if any database is outside the monitor thresholds.

Note

If your database uses Unlimited max size values, they will not be included in the tablespace check.  In this case it is often more appropriate to use the File System Capacity monitor to check the overall usage on the volume hosting your database.

Review Database Monitors section SQL Server Tablespace Check.