AppManager ResponseTime for Microsoft SQL Server 7.3.0.1 Release Notes

Date Published: January 2020

NetIQ AppManager ResponseTime for Microsoft SQL Server provides a set of transactions that can be run from client computers to SQL servers. These transactions resemble actual SQL Server transactions and appear the same to the network components that process them. The Knowledge Scripts use these transactions to measure and monitor the availability and response time of typical SQL queries. You can deploy them from any sites served by SQL Server.This release improves usability and resolves previous issues. Many of these improvements were made in direct response to suggestions from our customers. We thank you for your time and valuable input. We hope you continue to help us ensure our products meet all your needs. You can post feedback in the AppManager forum on Qmunity, our community Web site that also includes product notifications, blogs, and product user groups.

1.0 What’s New?

This release of AppManager ResponseTime for Microsoft SQL Server provides the following enhancements:

  • Support for installing your version of Microsoft SQL Server using SQL Server 2019. This release of NetIQ AppManager ResponseTime for Microsoft SQL Server supports SQL Server 2019.

  • Support for Microsoft Windows Server 2019. This release of NetIQ AppManager ResponseTime for Microsoft SQL Server supports Windows Server 2019.

  • Support for Transport Layer Security (TLS) 1.2. This release of NetIQ AppManager ResponseTime for Microsoft SQL Server supports Transport Layer Security (TLS) 1.2.

This release of AppManager ResponseTime for Microsoft SQL Server replaces all Previous Releases.

2.0 System Requirements

AppManager ResponseTime for Microsoft SQL Server has the following system requirements:

Software/Hardware

Version

NetIQ AppManager installed on the repository, agent, and console computers

6.0, at minimum

AppManager provides setup programs to install this module on AppManager 6.x and AppManager 7.x. Run the setup program appropriate for your version of AppManager.

NetIQ AppManager installed on the repository, agent, and console computers

7.x, at minimum

Microsoft operating system installed on the agent computers

One of the following versions:

  • Windows Server 2019

  • Windows Server 2012 R2

  • Windows Server 2012

  • Windows Server 2008 R2

  • 32-bit and 64-bit Windows Server 2008

  • 32-bit Windows 2000, SP2

  • 32-bit Windows XP Professional, SP2

  • 32-bit Windows Vista

  • 32-bit Windows Server 2003

Microsoft SQL Server

One of the following versions:

  • SQL Server 2019

  • SQL Server 2014

  • SQL Server 2012

  • SQL Server 2008 R2

  • SQL Server 2008

  • SQL Server 2005

  • SQL Server 2000

MDAC installed on the agent computers

Version 2.5 or later

Data Source Names

Configured with ODBC to use either the ADO or ODBC DSN Knowledge Scripts.

Microsoft SQL Server Native Client 11.0

(for TLS 1.2 support)

11.3.6538.0 or later

NOTE:The SQL Server Native client can be installed from this Microsoft download link.

NOTE:If you want TLS 1.2 support and are running AppManager 9.1 or 9.2, then you are required to perform some additional steps. To know about the steps, see the article.

For the latest information about supported software versions and the availability of module updates, visit the AppManager Supported Products page at www.netiq.com/support/am/supportedproducts/default.asp. If you encounter problems using this module with a later version of your application, contact NetIQ Technical Support.

For more information about system requirements for the AppManager ResponseTime for Microsoft SQL Server agent, repository, and management server, see the Installation Guide for AppManager.

3.0 Contents of the Download Package

AppManager ResponseTime for Microsoft SQL Server includes Knowledge Scripts to discover and monitor SQL Server resources, and several managed objects shared among the ResponseTime modules: netiqxml.dll, netiqprops.dll, qsermona4.dll, xmlservmona.dll, qcomcnfg.dll, qcma.dll, qdbrt.dll, and qrtdisc.dl. The download package includes this release notes, management guide, Help for Knowledge Scripts, and several files that are used during installation:

  • AM70-SQL-RT-7.3.115.0.msi, the application module setup program.

  • AM70-SQL-RT-7.3.115.0.ini, a configuration file used with the AppManager setup program.

  • AM70-SQL-RT-7.3.115.0.xml, a configuration file used for deploying the module with Control Center. This is the file you check into the Control Center Web Depot.

  • AM70-SQL-RT-7.3.115.0-RepositoryFiles.exe, a compressed file that contains the QDB and console files. You do not need to run this file during installation.

  • ckSQL-RT.exe, the pre-installation check used with the AppManager setup program.

When you download the module, these files are copied by default to the local folder on the download computer. Consider copying these files to the \windows_installation\setup\Setup Files folder on the same distribution computer on which you saved your main AppManager software and documentation. By doing so, you maintain all AppManager software in one location that is easily accessible when you want to add more repositories, management servers, or agents.

4.0 Installing This Module

Run the module installer to install the module components in the following locations:

  • On the SQL computers you want to monitor (agents) to install the agent components

  • On all console computers to install the Help and console extensions

Run the module installer only once on each of these computers.

Important This release provides SQL stored procedures. To ensure module functionality, run the module installer for each QDB attached to Control Center.

  • When installing to each QDB, select the option to install Knowledge Scripts, and then specify the SQL Server name of the server hosting the QDB, as well as the case-sensitive QDB name.

  • If Analysis Center reports are available for this module, select the option to install Analysis Center reports, and then specify the SQL Server name of the server hosting the Analysis Center Configuration Database.

IMPORTANT:This release provides SQL stored procedures. To ensure module functionality, run the module installer for each QDB attached to Control Center.

You need to install Knowledge Scripts and Analysis Center reports only once per database. The module installer now installs Knowledge Scripts for each module directly into the QDB instead of the \AppManager\qdb\kp folder as in previous releases.

Backlevel SQL-RT Knowledge Scripts are not supported. Backlevel Knowledge Scripts are defined as Knowledge Scripts from versions earlier than version 6.4, which became available in May 2006. If you have backlevel Knowledge Scripts running in your AppManager management site, upgrade them to the current version.

For more information about installing this module, see the AppManager ResponseTime for Microsoft SQL Server Management Guide, included in the download package.

5.0 Known Issues

NetIQ Corporation strives to ensure our products provide quality solutions for your enterprise software needs. AppManager ResponseTime for Microsoft SQL Server had no known issues at the time of release. If you need further assistance with any issue, please contact Technical Support.

  • 64-bit resources do not fail the pre-requisite check at install. AppManager ResponseTime for Microsoft SQL Server does not support 64-bit platforms. However, the presence of 64-bit components on the computers on which you install the module does not cause the pre-requisite check to fail. In addition, the pre-requisite check HTML report does not contain results of the test for 32- or 64-bit components. (ENG266301)

6.0 Previous Releases

This release of AppManager ResponseTime for Microsoft SQL Server includes enhancements added in previous releases.

6.1 Release 7.1.138.0, August 2015

This release of AppManager ResponseTime for Microsoft SQL Server provides the following enhancements:

  • Support for Microsoft Windows Server 2012 R2, Windows Server 2012, Windows Server 2008 R2, and 64-bit Windows Server 2008. This module now supports Windows Server 2012 R2, Windows Server 2012, Windows Server 2008 R2, and 64-bit Windows Server 2008. For more information, see the System Requirements.

6.2 Release 7.1.138.0, April 2009

This release of AppManager ResponseTime for Microsoft SQL Server resolved the following issue:

  • SQL-RT_ODBCDSNQuery job fails when duplicate objects exist. Before you install this release, the SQL-RT_ODBCDSNQuery Knowledge Script job fails with the following error: Subquery returned more than 1 value. The error results from two objects in the repository having the same name. After you install this release, a change in the code for the SQL query accommodates duplicate object names and allows the SQL-RT_ODBCDSNQuery Knowledge Script job to run. (ENG258705)

6.3 Release 71331, November 2008

Hotfix 71331 resolved the following issues:

  • ODBCQuery script does not raise events when SQL Server is down. Before installing this release, the SQL-RT_ODBCQuery Knowledge Script does not raise events or collect data when SQL Server is down. After you install this release, a code change prevents the ODBC driver from becoming unresponsive, or hanging, thereby allowing the ODBCQuery script to raise events and collect data when SQL Server is down. (ENG254941)

  • Multi-word DSN names raise errors. Before installing this release, the SQL-RT_ADODSNQuery and SQL-RT_ODBCDSN Knowledge Scripts raise errors when you attempt to use DSN names that consist of more than one word, such as SQL2000 Server. The scripts interpret the multi-word DSN name as two separate DSN names. After installing this release, the scripts successfully interpret multi-word DSN names. (ENG256168)

  • SQL passwords raise errors. Before installing this release, the SQL-RT_ADODSNQuery Knowledge Script cannot interpret certain SQL logon passwords. After installing this release, the script successfully interprets SQL logon passwords. (ENG256261)

6.4 Release 7.1, March 2007

This release offered the following enhancements and fixes:

  • Event proxying capability: You can now select the resource object where events are shown in the console TreeView. This feature supports the Service Map Viewer component of Control Center. You can select whether events generated by the ResponseTime for SQL Server managed object appear on the Agent, on the Server, or Both.

  • Backlevel Knowledge Script support discontinued: To support architectural and build enhancements, including a smaller installation profile, all Knowledge Scripts from versions earlier than version 6.4 of AppManager ResponseTime for SQL Server have been deprecated. These Knowledge Scripts will fail if you try to run them.

7.0 Contact Information

Our goal is to provide documentation that meets your needs. If you have suggestions for improvements, please email Documentation-Feedback@netiq.com. We value your input and look forward to hearing from you.

For detailed contact information, see the Support Contact Information website.

For general corporate and product information, see the NetIQ Corporate website.

For interactive conversations with your peers and NetIQ experts, become an active member of our community. The NetIQ online community provides product information, useful links to helpful resources, blogs, and social media channels.