Use this Knowledge Script to monitor the accessibility of SharePoint content databases for the Web applications running on the SharePoint server. This Knowledge Script raises an event if the content databases on the SharePoint server or SQL servers are not accessible.
This script collects data about the availability of the content databases. A value of 0 means that the status of the database is Offline for either the SQL servers or the SharePoint server. A value of 100 means that the status of the database is Online for the SQL servers and the SharePoint server.
When you run this Knowledge Script on a SharePoint Database in the Navigation pane (for Control Center) or the TreeView (for the Operator Console), this Knowledge Script monitors all content databases under the parent Database object. To monitor only certain content databases, open the Object tab and deselect the databases you do not want to monitor.
Before you can run the ContentDatabaseAccessibility 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 ContentDatabaseAccessibility 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 ContentDatabaseAccessibility script.
SharePoint Server: Database
The default interval for this script is every hour.
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 the accessibility of the SharePoint content databases. The default is 5. |
Monitor Content Database Accessibility |
|
Comma-separated list of content databases to exclude |
Specify a list of the content databases to ignore when monitoring. Use commas without spaces to separate multiple content databases. |
Event Notification |
|
Raise event if content databases are inaccessible? |
Select Yes to raise an event if the content databases are not accessible. The default is Yes. |
Event severity when content databases are inaccessible |
Set the event severity level, from 1 to 40, to indicate the importance of an event when the content databases are not accessible. The default is 10. |
Data Collection |
|
Collect data for content database accessibility? |
Select Yes to collect data about the accessibility of the content databases. The default is unselected. |