The SQL Server Tablespace Check monitor connects directly to the database instance and runs the following set of commands to verify tablespace usage:
- Uses the name field to find more information about each database served by the instance.
- 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.
Review Database Monitors section SQL Server Tablespace Check.