IBM Support

Change History of Monitoring Agent for Microsoft SQL Server

Product Readmes


Abstract

Change History of Monitoring Agent for Microsoft SQL Server

Content

Product version Release date Agent version     What’s new
APM 8.1.4.0.21 March 2024 08.24.03.00
  • General improvements
  • Added Watchdog feature for Red Hat Enterprise Linux platforms.
APM 8.1.4.0.20
May 2023 08.23.05.00
  • Added support for Microsoft SQL Server 2022
  • Fixed UI issues related to SQL Server edition and Services widget data for Microsoft SQL Server 2022
APM 8.1.4.0.19 November 2022 08.22.10.00
  • Fixed access memory consumption issue
  • Fixed security issues
  • Integrated enhancements and defect fixes that were implemented in CP4MCM 2.3.0.1 release.
APM V8.1.4.0.18 April 2022 08.22.04.00
  • General Improvements
  • Added support for Windows Server 2022 (Datacenter and Standard editions)
CP4MCM 2.3.0.1 January 2022 08.22.01.00
  • Upliftment to Visual Studio 2013.
  • Added support for Windows Server 2022.
APM V8.1.4.0.17 October 2021
08.21.09.00
  • General Improvements
  • The new CUSTOMIZED_QUERY_TIMEOUT environment variable added to set the customized query timeout interval (in seconds) for any attribute group.
  • For Windows 64-bit operating system, Microsoft Visual C++ is upgraded to 2013 from 2008. Windows 32-bit operating system is not supported by V8.1.4.0.17 or later releases.
APM V8.1.4.0.16 June 2021 08.21.06.00
  • General Improvements
  • RFE 147580: Added support to monitor databases with size more than 20TB database.
  • Added support for Virtual Service account, Managed Service account and Group Managed Service account.
APM V8.1.4.0.15 March 2021 08.21.03.00
  • General Improvements
  • The option for disabling Long Live Database connection is removed from the agent configuration. From 8.1.4.0.15 release, Support Long Lived Database Connections will be enabled by default.
  • The non-required configuration parameters are reduced on Linux platform to configure agent easily.
APM V8.1.4.0.14 December 2020 08.20.12.00
  • Agent can now send attribute group data to server if data collection takes more than 45 seconds. 
  • User override files (oq.environment and oq_${inst}.environment) are generated for MS SQL Agent on Linux platform, which will preserve the user override environment variables on agent upgrade.
  • Added support to configure Device Details attribute group as demand-based on Linux platform. By default, Device Details attribute group is demand-based and user can set COLL_KOQDEVD_INTERVAL value in minutes in oq.environment file to make it interval based.
APM V8.1.4.0.13 September 2020 08.20.09.00
  • General Improvements
CP4MCM 2020.2.0 August 2020 08.20.08.00
  • General Improvements
APM V8.1.4.0.12 June 2020 08.20.06.00
  • General Improvements
  • APAR IJ23861: When ms sql agent tries to refresh performance counters, crash occurs when a third party performs counter library throws an exception.
ICAM 2020.1.0.1
 April 2020 08.20.04.00
  • General improvement.
APM V8.1.4.0.11
ICAM 2020.1.0
 March 2020 08.20.03.00
  • Tolerance support for SQL Server 2019 was added.
  • General improvement.
ICAM 2019.4.0.2 February 2020 08.20.02.00
  • Added Golden Signal widgets.
APM V8.1.4.0.10
 December 2019 08.19.13.00
  • General improvement.
ICAM 2019.4.0 December 2019 08.19.12.00
  • General improvement.
ICAM 2019.3.0.1 October 2019 08.19.10.00
  • General improvement for Linux platform.
APM V8.1.4.0.9
ICAM 2019.3.0
 September 2019 08.19.09.00
  • Provided MSSQL agent support on Linux Platform
ICAM 2019.2.1.1 July 2019 08.19.07.00
  • The widget Job details is enhanced to display the Success count and Non-success count.
APM V8.1.4.0.8
 June 2019 08.19.06.00
  •  Added licensing support for resource monitoring.
ICAM 2019.2.0.1
 May 2019 08.19.06.00
  • Fixed the transactions slowness on the ICAM UI.
APM V8.1.4.0.7 March 2019 08.19.03.00
  • Added the support of Windows Server 2019.
V8.1.4.0.6 December 2018 6.31.18.00
  • General improvements.
  • APAR IV99415: SQL Agent did not preserve "Override Local Settings" section while upgrading from versions 06.31.08.00 and lower to versions 06.31.08.01 and above.
  • APAR IJ10466: Table detail workspace did not show any data if SQL server 2014 onwards database collation was set to case sensitive as the newly added queries for SQL server 2014 onwards are using table/view column names in different case than the server table/view column.
  • Connection string extended to take "ApplicationIntent" as an input by adding KOQ_APPLICATION_INTENT environment variable. Possible values are "Readonly" and "Readwrite". This will enable accessing data from secondary databases with property readable secondary =read-intent only.
V8.1.4.0.4 July 2018 6.31.17.00
  • RFE 42812: Support for multiple collations in ERRORLOG parsing based on collation settings in koqErrConfig.ini file.
  • Utility tool koqVerifyPermissions.exe to check if an existing SQL Server user has sufficient permissions to monitor the Microsoft SQL Server.
  • Utility tool permissions.cmd as an alternative to grant the minimum permissions to an existing SQL Server user for data collection.
V8.1.4.0.3 April 2018 6.31.16.00
  • General improvements.
V8.1.4.0.2 February 2018 6.31.15.00
  • General improvements.
  • Added cluster utility.
V8.1.4.0.1 December 2017 6.31.14.00
  • Tolerance support for SQL Server 2017 was added.
  • Support for Always On feature for the SQL Server developers edition was added.
  • APAR IJ05451: Fixed Microsoft SQL Server Agent's collector process crash when SQL Server Native Client Driver is used.
  • APAR IV96443: Fixed Job detail attribute group to showing correct values for jobs having double quotes in job name.
  • APAR IJ00433: Fixed the collector process crash occurring while accessing invalid parameter of the request.
  • APAR IJ04072: Fixed table detail attribute group memory leak when the table count is higher than 35K.
  • APAR IJ00815: Fixed the case when data file autogrowth was disabled and data freespace was greater than device freespace then incorrect values were seen for some attributes.
V8.1.4 August 2017 6.31.12.00
  • The Expensive Queries group widget was added to the Server Performance – Detail page to view the top 10 cached query plans according to the performance statistics of the Microsoft SQL Server.
  • Support for monitoring the Microsoft SQL Server 2016 was added.
  • Support for installing and configuring the Microsoft SQL Server agent on a Microsoft Windows Server 2016 system was added.
  • The new COLL_ERRORLOG_RECYCLE_WAIT environment variable was added to set the time interval (in seconds) for which the agent waits before it collects the MS SQL Error Event Detail attribute group data.
V8.1.3.2 April 2017
(SaaS only)		 6.31.11.00
  • Added the Expensive Queries group widget in the Server Performance –
    Detail page to view the top 10 cached query plans according to the performance
    statistics of the Microsoft SQL Server.
  • Added support for monitoring the Microsoft SQL Server 2016.
  • Added support to install and configure the Microsoft SQL Server agent
    on the Microsoft Windows Server 2016 system.
  • Added the new COLL_ERRORLOG_RECYCLE_WAIT environment variable to set the
    time interval (in seconds) for which the agent waits before collecting data of
    the MS SQL Error Event Detail attribute group.
  • APAR IV87045: Removed admin check in pre-requisite check as it was failing for non admin user
V8.1.3 April 2016
(SaaS only)		 6.31.09.00
  • General improvements.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVJUL","label":"IBM Application Performance Management"},"Component":"Monitoring Agent for Microsoft SQL Server","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"Linux support is provided from APM V8.1.4.0.9. Windows support is applicable for all agent versions","Edition":"","Line of Business":{"code":"LOB67","label":"IT Automation \u0026 App Modernization"}}]

Document Information

Modified date:
22 March 2024

UID

ibm10879937

Page Feedback