9.6.00 enhancements

This topic contains information about enhancements in version 9.6.00 of the BMC PATROL for Microsoft SQL Server product and provides instructions for downloading the installation files.

Tip

Enhancements

Monitoring remote environments

The BMC PATROL for Microsoft SQL Server product provides remote monitoring of SQL Servers. The primary focus of PATROL for Microsoft SQL Server is to monitor remote hosts, which hold multiple SQL Server instances. 

Monitoring perfmons

With the MSSQL_SERVER_PERFMON application classes, you can monitor Microsoft Performance Monitor counters. See, Configuring perfmons for more information.

Monitoring Custom SQL queries

BMC PATROL for Microsoft SQL Server supports custom query configuration to fetch specific information about the query. See Configuring custom SQL queries for more information.

Support for monitoring clustered environments  

PATROL for Microsoft SQL Server monitors SQL Servers in a clustered environment. See Monitoring SQL Server failover cluster environment for more information.

Updates

BMC PATROL for Microsoft SQL Server 9.6.00 provides the following updates:

Tracking ID *

Updates

QM001690825

Metrics added to monitor query timeout and blocking issue.

QM001696020

Option added to filter MS SQL Agent jobs for filtering. For filtering options, see Environment configuration dialog box.

QM001698014

Parameter added to indicate the amount of time elapsed since the last back up

QM001699659

Enhancement added to view the desired cluster node in the SQL instance without opening the InfoBox.

QM001706993

Option added to support monitoring of SQL Agent hung jobs.

QM001711393

Updated the PATROL for Microsoft SQL Server documentation to align performance counters with PATROL counters.

QM001726252

Updated the following for LongRunningTrans and BlockerProcs parameters:

Enhanced the recovery action to run on consecutive alarm polls and send new corresponding events with updated annotation details.

QM001727718

Updated the SQLAgentJobFailures (MS SQL Server Agent Health application class) parameter to automatically detect the number of failed jobs and reset itself.

QM001732473

Option added to delete a monitored database.

QM001739176

Enhanced the instance name field to allow regular expressions for all types of rules.

QM001740758

Updated the PATROL for Microsoft SQL Server KM to support MS SQL Workgroup edition.

QM001748012

Updated the LongRunningTrans and ProcedurecacheColl parameters to use SQL queries instead of the dbcc command. 

QM001757699

Enhanced the PATROL for Microsoft SQL Server KM to support monitoring of Log Shipping when a database is in a restoring state.

QM001765905

Option added for removing an SQL instance.

QM001768910

Enhanced the PATROL for Microsoft SQL Server KM to support remote monitoring and external cluster agent capabilities.

QM001781918

Enhanced the PATROL for Microsoft SQL Server KM to configure a cluster environment with multiple instances using PATROL Configuration Manager.

QM001791558

Added database backup parameters in PATROL for Microsoft SQL Server KM.

QM001791575

Added the parameter which reports the time (in seconds) for which the instance has been up and running.

QM001829644

Microsoft SQL Server 2014 support added for PATROL for Microsoft SQL Server 9.6.00

QM001829964

Added the parameter which alarms when BlockerProcs and LongRunningTrans parameters are in alarm state.

QM001849508

Enhanced the KM to disable monitoring of disabled SQL Agent jobs using the SQLAgentJobFailures parameter.

QM001858525

Enhanced the PATROL for Microsoft SQL Server to generate alarms when there is a change in the monitoring user password. See SQL Connection Status (SQLConnectionStatus) parameter for more information.

QM001791560

Added the following database parameters to enhance the database monitoring.

QM001789966, QM001769123

Log monitoring feature was removed from PATROL for Microsoft SQL Server v9.6.00. Since this version, Log Management KM can be used to monitor log files.

QM001823624 

In PATROL for MSSQL Server, monitoring of synchronization_health parameter (MS SQL Server Always-On Availability Group application class) is supported as a logical parameter and not from Microsoft views (either a virtual table or a stored query). This parameter reports a rollup of the synchronization health of all availability replicas in the availability group. See Synchronization Health (SynchronizationHealth) parameter for more information. 

QM001789060

Enhanced the KM to filter MS SQL Agent jobs for multiple instances on the environment level.

Community Idea- 5371

Enhanced the KM to enable SQL Agent monitoring. For more information, see MS SQL Server Agent Health (MSSQL_SERVER_AGENT_HEALTH) and MS SQL Server Agent Statistics (MSSQL_SERVER_ AGENT_CONTAINER) application classes.

Community Idea- 2224

Enhanced the KM to support Pending Recovery and Emergency states of a database.

Community Idea- 2684

Enhancement added to support 32-bit and 64-bit versions of the KM on a 64-bit operating system.

Community Idea-2716

Enhancement added to the SQLAgentJobFailures parameter to monitor the SQL Agent jobs that are stopped manually.

* RFEs (Request For Enhancements) submitted directly or through a support representative, are tracked using 'QM' numbers, whereas RFEs directly submitted on  BMC Communities Open link  are marked as Community Ideas.

Related topic

Known and corrected issues

Was this page helpful? Yes No Submitting... Thank you

Comments