Benchmark Factory® for Databases

Version 5.8.1

Release Notes

May 2009


Contents

Welcome to Benchmark Factory for Databases

New in this Release

Resolved Issues and Enhancements

Known Issues

Upgrade and Compatibility

System Requirements

Global Operations
 

Getting Started

For More Information


Welcome to Benchmark Factory for Databases

Quest Software is pleased to make available Benchmark Factory® for Databases 5.8.1 to meet your database workload testing needs. Benchmark Factory is a database performance and code scalability testing tool that simulates users executing transactions on the database and replays production workloads in non-production environments. This enables developers, DBAs, and QA teams to validate database scalability as their user load increases, application changes are made, and platform changes are implemented. Benchmark Factory is available for Oracle, SQL Server, DB2, Sybase, MySQL, and other databases via ODBC connectivity. Benchmark Factory:

Upon completion of a test execution, all test results are collected and stored in the repository for data analysis and reporting. Benchmark Factory collects a variety of informative and detailed statistics that include:


New in This Release

Future Direction of Benchmark Factory for Databases

Quest Software has been committed to constant improvement of Benchmark Factory® for Databases for over ten years and will maintain this commitment for the foreseeable future. Benchmark Factory® for Databases will continue to be an industry leading load testing and scalability tool for the DBA and database developers. We will maintain our heterogeneous support for database platforms, including native support for Oracle and MS SQL Server, and support for DB2, MySQL, and Sybase via ODBC. We are committed to continued integration with our flagship Toad for Oracle product, hugely popular amongst Oracle developers and DBAs alike over the last ten years.

Because our focus is on the DBA and Developer user community and not necessarily on the large scale performance testing market, Quest software will be providing a more focused approach to supporting this customer base by limiting the amount of concurrent virtual users that will be supported on a single test. Moving forward, we will support only those instances where users are testing concurrent user loads no greater than 2,500 virtual users in a single test. This support limitation will also apply to the use of Benchmark Factory Agents. Quest Software will support no more than five agents in a single test scenario. While the product currently allows user loads and agent distribution greater than the afore mentioned amounts, support will only be provided in those scenarios where the user is working within the designated parameters.

This change is effective on Sep 17, 2008 for all supported versions of Benchmark Factory for Databases.

In future releases of Benchmark Factory® for Databases, we will be building these limits into the tool but until then, this will serve as notification that the support offering for Benchmark Factory has changed with the strategy of the product.

New for 5.8.1

New for 5.8


Resolved Issues and Enhancements

The following is a list of issues addressed in this release of Benchmark Factory for Databases.

Resolved Issue

Change Request

Added support for cursor bind datatypes.

40857

Enabled reconnect for SQL Sever ODBC driver

48554

Fixed errors when loading TPC-H tables on a SQL Server database with Polish language settings.

50843

When using stored procedure imports for Oracle, the user had to use the ALL_OBJECTS when the specified user did not have permissions

to the DBA_OBJECTS.

51322

 

 

Fixed BMF shutdowns when creating a custom load scenario with an SQL_Server trace import. 54852
Stack overflow errors occurs during certain Oracle trace file playback. 56177
When using BMF load balancing in an Oracle profile, an error occurs saving the node level test results. 61535

Known Issues

The following is a list of issues known to exist at the time of this Benchmark Factory for Databases release.

Feature

Known Issue

Change Request

Benchmark Factory Console Benchmark Factory does not support data types that are created by the user. N/A

Upgrade and Compatibility

Licensing


System Requirements

Before installing Benchmark Factory for Databases, ensure your system meets the following minimum hardware and software requirements:

Repository Benchmark Factory cannot run without a repository, and by default a MySQL repository is installed during the install process.  After installation, you can remove the MySQL service and delete the MySQL repository, then select  a repository of your choice. Benchmark Factory supports the following databases:
  • Oracle
  • SQL Server
  • MySQL
  • Sybase Adaptive Server Anywhere (iAnywhere)
Platform 1.0 GHz x86 or x64 compatible CPU
Memory 512 MB of RAM recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system.
  • Size and complexity of the database.
  • Amount of database activity.
  • Number of concurrent users accessing the database.
Hard Disk Space 120 MB of disk space for installation

Note: The disk space required may vary based on options selected for installation.

 
Operating System Microsoft® Windows 2000, 2003, 2008, XP Professional, and Vista
Database Client/Server Versions Oracle: 8, 8i, 9i, 9.2, 10g, and 11g (Note: Requires Oracle 8.1.7 client libraries or higher.)

SQL Server: 7, 2000, 2005, and 2008

Sybase: 12.5 and 15

DB2 LUW: 8.1.5 through 9

MySQL: 4.5 and 5.x

 

All client libraries require the 32-bit versions.


Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

The platforms and configurations supported in this release may use any time zone, character encoding, language, or locale configuration to operate this product. All components of this product must/should be configured to use the same or compatible character encodings and must/should be installed to use the same locale and/or regional options.

This release has been tested with the following language and platform combinations in addition to U.S. English:


Getting Started

Contents of the Release Package

The Benchmark Factory for Databases release package contains the following products:

  1. Benchmark Factory for Databases version 5.8.1
  2. Product Documentation, including:

For More Information

Get the latest product information, find helpful resources, and join a discussion with the Benchmark Factory for Databases Quest team and other community members. Join the Benchmark Factory for Databases community at http://benchmarkfactory.inside.quest.com.

Contacting Quest Software:

Email info@quest.com
Mail Quest Software, Inc.
World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656
USA
Web

http://www.quest.com

Refer to our web site for regional and international office information.

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.

The guide is available at: http://support.quest.com/pdfs/Global Support Guide.pdf.


© 2009 Quest Software, Inc.

ALL RIGHTS RESERVED.

 

This document contains proprietary information protected by copyright. The software described in this document is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

 

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

 

www.quest.com

Email: legal@quest.com

Refer to our web site for regional and international office information.

Trademarks

Quest, Quest Software, the Quest Software logo, Aelita, Akonix, Akonix, AppAssure, Benchmark Factory, Big Brother, ChangeAuditor, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

 

Disclaimer

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.