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.
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:
In AppManager Security Manager, select the AppManager agent or agents you want to monitor using SQL authorization.
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. |
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.
SharePoint Server: Database
The default interval for this script is every 30 minutes.
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. |