article How does the SQL Server Tablespace Check monitor work?

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.

Related Articles


Process Check monitor does not check the full Solaris path

RatingViews
article

Problem: At times the Check for a Process (Process Check) monitor may not check against a processes full path on Solaris systems. The up.time agent uses the "ps" command to match running processes....

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 9-9-2011 | Index: 236

  4607

Does the HTTP monitor work with NTLM authentication?

RatingViews
article

Current Windows based NTLM authentication to web sites is not supported by the HTTP or Web Application Transaction service monitors.

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 8-10-2011 | Index: 304

  3191

How to monitor MySQL Databases with up.time

RatingViews
article

Find out how to use up.time to effectively monitor your MySQL servers and database structures.

By: uptime Support | Date Created: 5-17-2007 | Last Modified: 6-28-2011 | Index: 176

  11380

I/O Exception Occurs When Performing a Ping Check

RatingViews
article

This article explains how to correct an I/O exception error that may occur when up.time runs a default ping check.

By: uptime Support | Date Created: 6-26-2007 | Last Modified: 6-28-2011 | Index: 202

  2836

How do I change a monitor's check or alerting frequency?

RatingViews
article

To change monitor's timing settings follow these steps 1) Click 'Services' 2) Use the main pane search options to locate the monitor you want to edit 3) Click the Edit icon beside the monitor...

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 8-25-2011 | Index: 343

  4473

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement