3.6 DBSpaceUtil

Use this Knowledge Script to monitor the amount of space used by a SharePoint content database. Space usage is measured in two ways: in megabytes, and as a percentage of the total database space available to the selected content database. The reported size of the content database includes both the content database (MDF file) and the transaction log files (LDF files).

This script raises an event if the size of a content database or the amount of space used by a content database exceeds the threshold you set.

3.6.1 Configuring Security Manager for DBSpaceUtil

Before you can run the DBSpaceUtil Knowledge Script, you need to configure AppManager Security Manager to enable the script to monitor the content databases using SQL authentication.

To configure Security Manager for the DBSpaceUtil Knowledge Script:

  1. In AppManager Security Manager, select the AppManager agent or agents you want to monitor using SQL authorization.

  2. On the Custom tab, add a custom entry and complete the following fields for the agent or agents you selected in the previous step:

    Field

    Description

    Label

    SharePoint_SQL

    Sub-label

    ServerName\SharePointInstanceName

    This field can be configured as default, which means that the SQL login credentials will be used to connect to any content database.

    To do this, type default in place of ServerName\SharePointInstanceName

    Value 1

    Specify the user name for the SQL Server account.

    Value 2

    Specify the password for the SQL Server account.

    Value 3

    Leave this field blank.

    Extended application support

    Required field. Encrypts the user name and password in Security Manager.

  3. Verify that the SQL login account has been granted the DB_owner role on the content databases you want to monitor with the DBSpaceUtil script.

3.6.2 Resource Objects

SharePoint Server: Database

3.6.3 Default Schedule

The default interval for this script is every 30 minutes.

3.6.4 Setting Parameter Values

Set the following parameters as needed:

Description

How to Set It

General Settings

Job failure event notification

Event severity when job fails

Set the event severity level, from 1 to 40, to indicate the importance of an event in which the job fails to monitor a SharePoint content database. The default is 5.

Event Notification

Raise event if the percentage of space used by the content database exceeds threshold?

Select Yes to raise an event if the percentage of space used by the content database exceeds the threshold you set. The amount of space used is the total space used by the content database and the transaction log files. The default is Yes.

Event severity when the percentage of space used by the content database exceeds the threshold

Set the event severity level, from 1 to 40, to indicate the importance of an event in which the percentage of space used by the content database exceeds the threshold you set. The default is 10.

Threshold -- Maximum amount of space used by the content database (in %)

Specify the maximum percentage of space the content database can use before an event is raised. The default is 75.

Raise event if the content database size exceeds threshold?

Select Yes to raise an event if the size of the content database exceeds the threshold you set. The reported size of the content database includes both the content database and the transaction log files. The default is Yes.

Event severity when the content database size exceeds the threshold

Set the event severity level, from 1 to 40, to indicate the importance of an event in which the size of the content database exceeds the threshold you set. The default is 15.

Threshold -- Maximum size of the content database (in MB)

Specify the maximum size of the content database, in megabytes, before an event is raised. The default is 500.

The maximum valid value is 204800.

Data Collection

Collect data for the amount of space used by the content database (in %)?

Select Yes to collect data for charts and reports. If enabled, data collection returns the amount of space utilized by the SharePoint content database, as a percentage. The default is unselected.

Collect data for the size of the content database (in MB)?

Select Yes to collect data for charts and reports. If enabled, data collection returns the size of the SharePoint content database, in megabytes. The default is unselected.