3.3 ContentDatabaseAccessibility

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.

3.3.1 Configuring Security Manager for ContentDatabaseAccessibility

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:

  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 ContentDatabaseAccessibility script.

3.3.2 Resource Objects

SharePoint Server: Database

3.3.3 Default Schedule

The default interval for this script is every hour.

3.3.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 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.