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 document outlines why you should install this release and identifies any known issues. We assume you are familiar with previous versions of this product. For more information about installing the module, see the AppManager ResponseTime for Microsoft SQL Server Management Guide, included in the download package.

Why Install This Release?

Release 7.1.138.0 of AppManager ResponseTime for Microsoft SQL Server resolves 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)

For more information about the issues resolved with this release, see NetIQ Knowledge Base article NETIQKB71512.

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

Return to Top

System Requirements

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

• AppManager version 7.x installed on the repository, agent, and console computers
• One of the following Microsoft operating systems installed on the agent computers:
  -- 32-bit Windows 2000, SP4
  -- 32-bit Windows XP Professional, SP2
  -- 32-bit Windows Vista
  -- 32-bit Windows Server 2003
  -- 32-bit Windows Server 2008
• MDAC version 2.5 or later installed on the agent computers
• DSNs configured with ODBC, to use either the ADO or ODBC DSN Knowledge Scripts

The AppManager Supported Products Web site contains a complete and up-to-date list of application versions.

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

Return to Top

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 Readme, a management guide, Help for Knowledge Scripts, and several files that are used during installation:

• AM70-SQL-RT-7.1.138.0.msi, the application module setup program.
• AM70-SQL-RT-7.1.138.0.ini, a configuration file used with the AppManager setup program.
• AM70-SQL-RT-7.1.138.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.
• 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 the Program Files\NetIQ folder on the download computer. We recommend that you copy these files to the \windows_installation\setup\Setup Files directory 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.

Return to Top

Installing This Release

Install the module on all agent computers, on all repository computers to install Knowledge Scripts, and on all console computers to install the Help. Run the setup program only once on each repository and agent computer.

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.

Return to Top

Known Issues

NetIQ Corporation strives to ensure our products provide quality solutions for your enterprise software needs. The following issues are currently being researched. 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)

Return to Top

Previous Releases

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

Hotfix 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)

For more information about the issues resolved with this release, see NetIQ Knowledge Base article NETIQKB71331.

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 appear 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 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.

Return to Top

Contact Information

Please contact us with your questions and comments. We look forward to hearing from you.

For detailed contact information, see the Support Contact Information Web site.

Return to Top

Legal Notice

NetIQ AppManager is protected by United States Patent No(s): 05829001, 05986653, 05999178, 06078324, 06397359, 06408335.

THIS DOCUMENT AND THE SOFTWARE DESCRIBED IN THIS DOCUMENT ARE FURNISHED UNDER AND ARE SUBJECT TO THE TERMS OF A LICENSE AGREEMENT OR A NON-DISCLOSURE AGREEMENT. EXCEPT AS EXPRESSLY SET FORTH IN SUCH LICENSE AGREEMENT OR NON-DISCLOSURE AGREEMENT, NETIQ CORPORATION PROVIDES THIS DOCUMENT AND THE SOFTWARE DESCRIBED IN THIS DOCUMENT "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. SOME STATES DO NOT ALLOW DISCLAIMERS OF EXPRESS OR IMPLIED WARRANTIES IN CERTAIN TRANSACTIONS; THEREFORE, THIS STATEMENT MAY NOT APPLY TO YOU.

This document and the software described in this document may not be lent, sold, or given away without the prior written permission of NetIQ Corporation, except as otherwise permitted by law. Except as expressly set forth in such license agreement or non-disclosure agreement, no part of this document or the software described in this document may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, or otherwise, without the prior written consent of NetIQ Corporation. Some companies, names, and data in this document are used for illustration purposes and may not represent real companies, individuals, or data.

This document could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein. These changes may be incorporated in new editions of this document. NetIQ Corporation may make improvements in or changes to the software described in this document at any time.

© 2009 NetIQ Corporation. All Rights Reserved.

U.S. Government Restricted Rights: If the software and documentation are being acquired by or on behalf of the U.S. Government or by a U.S. Government prime contractor or subcontractor (at any tier), in accordance with 48 C.F.R. 227.7202-4 (for Department of Defense (DOD) acquisitions) and 48 C.F.R. 2.101 and 12.212 (for non-DOD acquisitions), the government's rights in the software and documentation, including its rights to use, modify, reproduce, release, perform, display or disclose the software or documentation, will be subject in all respects to the commercial license rights and restrictions provided in the license agreement.

Check Point, FireWall-1, VPN-1, Provider-1, and SiteManager-1 are trademarks or registered trademarks of Check Point Software Technologies Ltd.

ActiveAgent, ActiveAnalytics, ActiveAudit, ActiveReporting, ADcheck, Aegis, AppAnalyzer, AppManager, the cube logo design, Change Administrator, Change Guardian, Compliance Suite, Directory and Resource Administrator, Directory Security Administrator, Domain Migration Administrator, Exchange Administrator, File Security Administrator, Group Policy Administrator, Group Policy Guardian, Group Policy Suite, IntelliPolicy, Knowing is Everything, Knowledge Scripts, Mission Critical Software for E-Business, MP3check, NetConnect, NetIQ, the NetIQ logo, the NetIQ Partner Network design, Patch Manager, PSAudit, PSDetect, PSPasswordManager, PSSecure, Risk and Compliance Center, Secure Configuration Manager, Security Administration Suite, Security Analyzer, Security Manager, Server Consolidator, VigilEnt, Vivinet, Vulnerability Manager, Work Smarter, and XMP are trademarks or registered trademarks of NetIQ Corporation or its subsidiaries in the United States and other jurisdictions. All other company and product names mentioned are used only for identification purposes and may be trademarks or registered trademarks of their respective companies.

Return to Top