9.6.20: Service Pack 4

This topic contains information about fixes and updates in this service pack. It also explains how to obtain the installation and other files that you need to install PATROL for Microsoft SQL Server.

What's new

Full monitoring coverage of SQL Server 2016 perfmon catalogs

PATROL for Microsoft SQL Server now supports monitoring of SQL Server 2016 external scripts performance monitor (perfmon) catalogs.

Enhanced Custom SQL query feature to annotate returned records

Enhanced Custom SQL query annotates returned records when the Number of Records has a value greater than zero.

What's changed

Database Status parameters are part of the Availability parameters list 

The parameters listed below are now part of the Availability parameters and the Monitor availability only option includes:

• Database Status
• Number of Offline Databases
• Number of Suspect Databases

Additionally, monitoring of Database Status includes the configuration of Database filtering options.

Higher rate monitoring using Custom SQL Query

Custom SQL Query feature now supports a minimum collection interval of one minute. In earlier versions, the minimum was two minutes.

Higher maximum value for all time-based parameters

All time-based parameters have a new maximum limit of 10080 minutes (one week). In earlier versions, the minimum was 120 minutes.

Enhanced custom SQL query value

A custom SQL query value is now enhanced to show data even when it returns more than one row, column or both as long as the data in the first row or column is numeric. In earlier versions when a query returned more than one row, column or both the parameter did not show the data.

Improved accuracy of SQL Agent Job Failures

The following are the methods to improve the accuracy of parameters:

1. If a job failed a few times during the last collection interval, it is considered as a single failure. This parameter counts the number of job failures, not the number of run failures.

2. If a step fails but the job succeeds, it is not considered a job failure. The entire job is a success even if one or more steps have failed.

3. If a job fails, the job annotates the last failed step.

4. Parameters do not detect SQL Agent Hung Jobs and SQL Agent Job Failures if the job is owned by a user who does not have a login account.

You can download the latest version of the KM by downloading a single KM installation file or by downloading the latest version of the Infrastructure Management-PATROL Repository. Use your preferred method of obtaining the installation files by completing one of the following procedures:

To download the PATROL for Microsoft SQL Server 9.6.20 installation file

The following table provides links to the pages in the EPD website that contain the installation files for this product. From the EPD page, select and download the installation files for your platform. Use your BMC Support credentials to access the EPD website. You might also be prompted to complete the Export Compliance Form.

Component	EPD link	Installtion file names
PATROL for Microsoft SQL Server 9.6.20	Download link	Windows  - pkm_mssql_ALL_9620.zip Linux/Unix - pkm_mssql_ALL_9620.tar
PATROL Installation Utility Version 10.7.00	Download link	Windows  - ins_WINDOWS_10700.zip Linux/Unix - ins_ALL_10700.tar

To download the Repository files

The following table provides links to the pages in the EPD website that contain the Repository files. From the EPD page, you can select and download the installation files for your platform. Access to the EPD website requires that you provide your BMC Support credentials. You might also be prompted to complete the Export Compliance Form.