Environment configuration dialog box

Environment name

Enter a unique environment name for monitoring the Microsoft SQL Server environment. A container will be created with the environment name. This environment will hold all the SQL Server instances. BMC recommends you to provide only alphanumeric characters in environment name.

User Name

Enter a unique, user-defined alias name, host name. User Name should contain domain name (DOMAIN_NAME\USER_NAME).

Password

Enter the password for the specified user.

User Name

Enter a unique username. This username is the MS SQL Server login that will be used for monitoring. If this field is left blank then, the Windows User credentials will be used to connect to the MS SQL server (Integrated Security).

Password

Enter the password for the specified user.

Availability collection interval (min)

Set the availability collection interval time.

Data collection interval (min)

Set the data collection interval time.

Device mapping

Select this checkbox to enable device mapping to consolidate the configured devices at the device level.

Logging

Select this checkbox to enable debug logging for the environment.

Next

Click to navigate to the Host configuration of environment envName dialog box.

Cancel

Click to exit without saving the configuration details.

Host name / IP address

Enter the FQDN or IP Address where the SQL Server is installed.

$HOSTNAME refers to the host on which PATROL Agent is installed. (Default value is $HOSTNAME)

Next

Click to navigate to the MS SQL server instance configuration for hostName in env envName dialog box

Prev

Click to return to the Environment configuration dialog box.

MS SQL Server instance name (regex)

Enter a regular expression of the MS SQL server instances to be discovered and monitored. Enter .* (dot asterisk) to discover all the available instances on host hostName.

Default value is .*

Monitor databases only

Select this checkbox to monitor only database related metrics. Monitoring of any other SQL server general metrics will be disabled.

Monitor availability only

Select this checkbox to monitor only availability related metrics. Monitoring of any other SQL server general metrics will be disabled.

Filtering mode

Specify the filtering type for the filtering the MS SQL Agent jobs by logins.

• None - Selects all available MS SQL Agent jobs by logins for filtering
• Include - Includes only the MS SQL Agent jobs by logins entered in the Include/Exclude from Monitoring field
• Exclude - Excludes the MS SQL Agent jobs by logins entered in the Include/Exclude from Monitoring field

Include/Exclude from monitoring (regex)

Enter a regular expression of the relevant MS SQL Agent jobs by logins to either include or exclude from filtering.

Filtering mode

Specify the filtering type for the filtering the MS SQL Agent jobs by categories.

• None - Selects all available MS SQL Agent jobs by categories for filtering
• Include - Includes only MS SQL Agent jobs by categories entered in the Include/Exclude from Monitoring field
• Exclude - Excludes the MS SQL Agent jobs by categories entered in the Include/Exclude from Monitoring field

Include/Exclude from monitoring (regex)

Enter a regular expression of the relevant MS SQL Agent jobs by categories to either include or exclude from filtering.

Filtering mode

Specify the filtering type for filtering the MS SQL Agent jobs by names.

• None - Selects all available MS SQL Agent jobs by names for filtering
• Include - Includes only the MS SQL Agent jobs by names entered in the Include/Exclude from Monitoring field
• Exclude - Excludes the MS SQL Agent jobs by names entered in the Include/Exclude from Monitoring field

Include/Exclude from monitoring (regex)

Specify a regular expression of the relevant MS SQL Agent jobs by names to either include or exclude from filtering

Filtering mode

Specify the filtering type for filtering the databases.

• None - Selects all available databases for filtering
• Include - Includes only the databases entered in the Include/Exclude from Monitoring field
• Exclude - Excludes the databases entered in the Include/Exclude from Monitoring field

Include/Exclude from monitoring (regex)

Specify a regular expression of the relevant databases to either include or exclude from filtering

Monitor files and file groups

Select this checkbox to enable monitoring of DB files and file groups.

Ignore file autogrowth

Select this checkbox to ignore file auto growth configuration for Space Used Percentage Metrics

Unique port number (optional)

Enter a unique port number.

Done

To continue with the configuration and to add more MS SQL server instances configuration details or add more hosts configuration details, click Done.

Cancel

Click to exit without saving the configuration details.