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.
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.
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:
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:
- 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.
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.
If a job fails, the job annotates the last failed step.
- 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|
|PATROL Installation Utility Version 10.7.00|
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.
|Installation files for the latest version of the Repository.|