Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Info

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.

Review For more information about this feature, see Database Monitors section SQL Server Tablespace Check.