9.6.30: Service Pack 5

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

Option to consider a job as failed as long as its last run was failed

PATROL for Microsoft SQL Server 9.6.30 provides you an option to change the way to calculate the value of the SQL Agent Job Failures parameter. The Job considered as failed as long as its last run was failed check box enables you to consider a job as failed as long as its last run was failed. Earlier, the job was considered as failed if and only if it failed during the collection interval. 

For more information, see Configuring Microsoft SQL Server monitoring profile.

Option to configure query timeout

You can now specify the number of seconds allowed for a query to complete before going into timeout. This time affects all the queries executed by the KM to collect data. Earlier, the query timeout value was set to 30 seconds and you could not change it.

For more information, see Configuring Microsoft SQL Server monitoring profile.

What's changed

Custom SQL Query Value parameter is shown as graph

By default, the Custom SQL query Value parameter is shown as a graph.

Updated annotation for the Long Running Transactions parameter

The annotation of the Long Running Transaction parameter also includes Transaction SPID and Transaction Text. Earlier, this parameter showed the following information only:

• Transaction ID
• Transaction Name
• Transaction Begin Time

To download the PATROL for Microsoft SQL Server 9.6.30 installation file

Select and download the installation files for your platform; see the following table. Use your BMC Support credentials to access the EPD website. You might also be prompted to complete the Export Compliance Form.

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.