Database Management Solutions

DATABASE MANAGEMENT

Database Management

Managing the Changing Database EnvironmentOrganizations today are challenged by delivering tangible business value from their database investments. Adding to

this challenge is the constant change inherent in complex, often heterogeneous environments. From application and

platform changes to increased user activity, such changes place added stress on both the database environment and the

professionals charged with ensuring their peak performance.

Quest Software provides the breadth and depth of technical expertise required to meet the challenges presented by an

ever-changing IT landscape.

As the industry-leading provider of heterogeneous database management solutions, Quest empowers database

professionals to develop new applications and improve existing ones. And our renowned database experts provide best

practices and proven techniques to help organizations maximize efficiency throughout the database lifecycle.

Quest database management solutions span multiple platforms, including Oracle, SQL Server, IBM DB2, MySQL and Sybase,

to deliver the functionality that database managers, administrators, developers and analysts need to be more productive.

Analysts Rank Quest #1 in Database Management

Quest solutions empower database professionals to:

• Plan and develop applications that deliver both functionality and optimal performance

• Optimize the database with automated tuning technology

• Validate that databases will scale with future end-user requirements before deployment

Database professionals who use Quest solutions can minimize time to deployment, meet service level agreements, reduce costs and optimize performance.

Quest solutions also provide an objective view of the entire database environment, so database professionals can efficiently resolve issues and ensure

availability. They have the tools needed to:

• Discover performance issues in production before they impact end users and service levels

• Diagnose the root cause of even the most complex performance bottlenecks

• Resolve performance problems regardless of skill set

• Administer the database effortlessly, including data backup and recovery

With Quest’s industry-leading development and administration tools, such as Toad®, Foglight®, Spotlight® and LiteSpeed, you have the control you need over

your database environment. And you have the power to improve database quality, productivity and performance.

Quest Solutions for Database Management Deliver Code Quality and Optimization

Toad®

Toad is the de facto standard for developers, DBAs and analysts. Toad increases productivity and application code quality, while providing an interactive

community to support the user experience. Toad is available for Oracle, SQL Server, DB2 and MySQL.

Benchmark Factory® for Databases

Benchmark Factory is a database performance and code scalability testing tool that simulates users and transactions on the database and replays

production workload in non-production environments. Developers, DBAs and QA teams can validate that their databases will scale as user load increases

and that application and platform changes have been implemented. Benchmark Factory is available for Oracle, SQL Server,

DB2, Sybase, MySQL and other databases via ODBC connectivity.

Quest® Code Tester for Oracle

Quest Code Tester for Oracle creates successful code for Oracle development groups. Rather than painstakingly writing

large amounts of test code, developers can generate it easily from user descriptions, then run tests with the press of a

button. Success or failure is automatically computed and presented to users via an easy-to-understand red light/green light

display. The result is that Quest Code Tester for Oracle integrates PL/SQL testing directly into development as a repeatable,

verifiable process.

SQL Navigator® for Oracle

SQL Navigator is a PL/SQL development tool that streamlines workflow by adding a drag-and-drop graphical user

interface to the PL/SQL development environment.

Quest® SQL Optimizer for Oracle

Quest SQL Optimizer offers a fully automated approach to maximizing SQL performance. It eliminates the manual, time-

intensive process of ensuring SQL code is performing as fast as possible.

Manage Performance and Availability

Foglight®

Foglight is a powerful application management solution that monitors every tier in the application technology stack,

including databases, networks, application servers and Web servers, alerting administrators to problems before they

impact end users. Foglight supports Oracle, SQL Server, DB2 and Sybase.

Spotlight®

Spotlight is a powerful and graphically rich diagnostics tool that accurately isolates database performance

problems in real time and visually displays all database activity in an intuitive user interface.

Spotlight ensures faster problem detection and resolution without the need to rely on

customized scripts or cumbersome utilities. Spotlight integrates with other Quest

products, such as SQL Optimizer and Benchmark Factory, and is available for

Oracle, Oracle RAC, SQL Server, DB2, Sybase and MySQL.

Quest® Performance Analysis

Performance Analysis offers a comprehensive solution for diagnosing

and tuning database workloads. Through advanced diagnostic features

and specially designed interfaces, Performance Analysis transforms

performance management into a faster, easier and more efficient

experience. Performance Analysis is available for Oracle and SQL Server.

Space Manager for Oracle

Space Manager is a comprehensive solution for optimizing capacity and

performance in Oracle databases. Its powerful reorganization, problem detection and

capacity planning tools help maximize existing storage resources with minimal impact on

applications and users.

Solutions for D atabase Managem

ent

D E L I V E R

M A N A G E

C O N T R O L

Spotlight has definitely saved us many

times. All of the DBAs at our company

use Spotlight on a daily basis to verify

that everything is running fine or to see

how any changes made have helped

improve a system’s performance.

The biggest advantage for us is that

it all works together. It integrates

everything we have to do, and the tools

themselves bring tremendous expertise

to our group. Our productivity has

definitely increased.

– Graham Houghton Data Architect

Lafarge

As a result of the fantastic time savings,

we instantly got more value from our

SAP consultants. I would say that from

the time savings alone, LiteSpeed for

SQL Server easily paid for itself within

the first week.

– Richard Hawkins Data Architect

Motability Operations Services

“

”

“

”

SharePlex® for Oracle

SharePlex provides a fault-tolerant replica of Oracle databases to ensure high availability and disaster recovery,

eliminate risks associated with migrations, improve performance of OLTP systems and optimize business intelligence

applications.

Quest® Capacity Manager for SQL Server

Capacity Manager provides a complete portrait of storage requirements with easily interpreted reports, charts and

graphs. A consolidated view permits management and control of all databases and data files from a single interface.

Growth of instances, databases and objects can be plotted, enabling evaluation of the most storage resource-

intensive portions of an architecture, and over-allocated space can be reclaimed from databases.

LiteSpeed™ for SQL Server

LiteSpeed is a fast and flexible backup and recovery solution that offers centralized reporting and industry-leading

compression technology.

Manage Change and Configuration

Toad® Data Modeler

Toad Data Modeler enables developers, DBAs and designers to create,

maintain and document quality database designs and structures across more

than 20 different platforms.

Change Director for SQL Server

Change Director provides complete control over

every aspect of database schema changes across your SQL Server

environment.

Security Control and Audit Management

InTrust® for Databases

InTrust for Databases is a database audit management product that

ensures corporate database assets remain secure by providing real-time,

detailed notification of such events as intrusion detection, data theft and

data fraud.

Solutions for D atabase Managem

ent

D E L I V E R

M A N A G E

C O N T R O L

Previous reorg tasks required

application downtime. However, Space

Manager enabled us to perform the

task without system downtime. In

addition to such convenience, SAP R/3-

related service speed has also improved

by more than 40 percent through the

reorg task.

– Dongjik Park Advisory Engineer, Samsung SDS

Samsung Electronics Co.

Toad improves productivity for both

our developers and DBAs. Thanks to

automated tools like Toad, developers

and DBAs can operate more efficiently

and independent of one another to

quickly analyze problems and tune the

databases.

– Brian Christensen Director of IT Business Systems

Cisco Systems

“

”

“

”

AwardsSQL Server Magazine Editor’s Choice Awards (August 2007)

LiteSpeed for SQL Server - Platinum award winner, Backup and Recovery

Spotlight on SQL Server - Platinum award winner, Database Monitoring Tools

Quest Central for SQL Server - Gold award winner, Database Management Tools

Quest Performance Analysis for SQL Server - Best Database Development and Administration product

“Attendee’s Pick” award at Microsoft TechEd (June 2007) Quest Software - Microsof Global ISV Partner of the Year (2007, 2004)

SQL Server Magazine Editor’s Choice Awards (August 2006)LiteSpeed for SQL Server — Platinum award winner, Backup and Remote/Disaster Recovery

SQL Turbo — Platinum award winner, Database Development

Speed Coefficient® 2.0 — Gold award winner, Performance and Monitoring

Spotlight® on SQL Server Enterprise — Best Database Development and Administration Product

“Best of TechEd” competition, sponsored by Windows IT Pro and SQL Server magazines (June 2006)

Spotlight on SQL Server — Preferred Product, Best SQL Tool category, “Readers’ Choice Awards 2006,”

sponsored by Redmond Magazine (May 2006)

LiteSpeed for SQL Server — Gold award winner, General Database Utilities category, TechTarget

“Products of the Year” competition (January 2006)

SQL Server Magazine Readers’ Choice Awards (September 2005)Quest Central® for SQL Server Performance Analysis — Best New Product (Rookie of the Year)

and Best Database Monitoring/Analysis Software

LiteSpeed for SQL Server — Most Innovative Product, Best Database Backup/Recovery/Archive Software

and Best Data Encryption Tool

Speed SQL IDE — Best Integrated Development Environment (IDE)

Speed Change Manager — Best Change and Configuration Management Tool

and Best Comparison and Synchronization Tool

Speed Coefficient — Best Database Performance-Tuning Tool

Quest Central for SQL Server — Winner in the Data Management Solutions category, “Best of TechEd Europe”

competition, sponsored by Windows IT Pro and SQL Server magazines (August 2005)

Quest Software — MySQL Partner of the Year 2005 (April 2005)

Toad® for Oracle 8.0 — Jolt Productivity Award in Business Integration and Data Tools category (March 2005)

Database Experts at Quest SoftwareQuest is home to several industry experts whose knowledge and experience help us develop innovative products

that meet the needs of database professionals worldwide. These experts are active in the IT community, sharing best

Johannes Ahrends, Oracle Expert

Mike Ault, Oracle Expert

Douglas Chrystall, SQL Server Expert

Claudia Fernandez, SQL Server/DB2/Oracle/Sybase Expert

Steven Feuerstein, Oracle PL/SQL Expert

David Gugick, Microsoft SQL Server MVP

Guy Harrison, Oracle and MySQL Expert

Kevin Kline, Microsoft SQL Server MVP

Patrick O’Keefe, SQL Server Expert

Gary Piper, Oracle Expert

Bryan Oliver, SQL Server Domain Expert

Bert Scalzo, Toad for Oracle, Data Warehousing and Data Modeling Expert

Jeff Smith, Toad Expert

Jim Wankowski, DB2 Expert

Delivering Business Value from Your Database Investments

Quest Software can help your organization deliver, manage and control complex database

environments. Our award-winning products for Oracle, SQL Server, IBM DB2, Sybase and

MySQL give you the power to improve database quality, productivity and performance. They

help you deliver tangible business value by minimizing time to deployment, meeting service

level agreements, reducing costs and optimizing performance.

About Quest Software, Inc.

Quest Software, Inc., a leading enterprise systems management vendor, delivers innovative products that help organizations

get more performance and productivity from their applications, databases, Windows infrastructure and virtual environments.

Through a deep expertise in IT operations and a continued focus on what works best, Quest helps more than 90,000

customers worldwide meet higher expectations for enterprise IT. Quest provides customers with client management as well

as server and desktop virtualization solutions through its subsidiaries, ScriptLogic, Vizioncore and Provision Networks. Quest

Software can be found in offices around the globe and at www.quest.com.

APPLICATION MANAGEMENT DATABASE MANAGEMENT WINDOWS MANAGEMENT

Please refer to our Web site for regional and international office information.

Quest Software Incorporated. • To learn more about our solutions, contact your local sales representativeor visit www.quest.com • Headquarters: 5 Polaris Way, Aliso Viejo, CA 92656, USA © 2008 Quest Software Incorporated. ALL RIGHTS RESERVED. Quest Software and its products are trademarks and registered trademarks of Quest Software, Inc. in the U.S.A. and/or other countries. All other trademarks and registered trademarks are property of their respective owners.

BRC_DBM_EW_Q208