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.

If your database uses Unlimited max size values, they are not 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.

For more information about this feature, see Database Monitors.

  • No labels