Toad DBA Suite for SQL Server
Visit shop.quest.com to buy this product online.
Buy Online »
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »

Toad DBA Suite for SQL Server

A Simplified Approach to SQL Server Database Administration

The Toad™ DBA Suite for SQL Server is a complete set of SQL Server DBA tools that automate maintenance tasks, ensure optimal performance, and mitigate the risk of change. It helps you easily increase accuracy and resolve issues before they impact production. You can also greatly reduce the risks associated with database vulnerability, performance bottlenecks, upgrades, patches, and more. With the Toad DBA Suite for SQL Server, you can work smarter, not harder — no matter how much experience you have as a DBA.

*This product is only available for purchase in EMEA, APACJ and Latin America.

Features

The Toad DBA Suite for SQL Server boosts productivity by enabling you to:

  • Automate, schedule, and simplify repetitive, time-consuming tasks
  • Use a smooth workflow through a single suite of integrated tools
  • Integrate with Quest SQL Optimizer for SQL Server for quick resolution of performance bottlenecks
  • View all managed databases collectively and drill down to objects and task execution — all within the same window
  • Manage SQL Server user accounts efficiently and accurately — without the use of scripts
  • Diagnose database performance bottlenecks through visual representations of SQL Server, Analysis Services, and SQL Azure database environments
  • Automate the SQL optimization process
  • Correlate SQL Server performance with corresponding Windows information
  • Evaluate the impact of database changes (upgrades, patches, new configurations, indexing) through database workload replay
  • Use what-if analysis to preempt SQL performance regression due to indexing
  • Deploy schema and data model changes

Sys Reqs

Client Requirements

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Platform

600 MHz minimum, 1 GHz recommended

Memory

512 MB of RAM minimum, 1 GB recommended

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

  • Applications that are running on your system when using Toad for SQL Server
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

104 MB to run Toad for SQL Server

Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Server 2003

Windows XP Professional (32-bit or 64-bit)

Windows Vista (32-bit or 64-bit)

Windows Server 2008 (32-bit or 64-bit)

Windows Server 2008 R2 (64-bit)

Windows 7 (32-bit or 64-bit)

Windows 8 (32-bit and 64-bit)

Important: Toad uses the Microsoft Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista, Windows Server 2008 and Windows 7. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.

.NET Framework

Microsoft .NET Framework 4.0

Note: The .NET Framework Client Profile is not supported.

Additional Requirements

Web Browser

Microsoft Internet Explorer 6.0 or later

Copy/Move Database Wizard

The SQL Server Backward Compatibility package is required to use the Copy/Move Database wizard.

Log Reader

The Log Reader requires version 8.0 DLL files in the Microsoft Visual C++ 2005 SP1 Redistributable Package. If these files do not exist on the client, you will need to install them to use some functionality in the Log Reader.

http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en

Server Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Database Server

Limited support of SQL Server 2000 (Service Pack 3 or later)

Note: The following features are not available:

  • Index Defragmentation
  • Storage Management
  • Performance Monitor
  • Project Lucy Performance Analytics
  • Altering procedures, functions, views in the Editor
  • Version Control

SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express

SQL Server 2008 and SQL Server 2008 Express

SQL Server 2008 R2 and SQL Server 2008 R2 Express

SQL Server 2012 and SQL Server 2012 Express

Note: SQL Server Compact Edition is not supported.

Cloud Database Service

SQL Azure

Note: To be able to utilize majority of Toad functionality please grant VIEW DEFINITION on the SQL Azure databases you want to work with.

Virtualization Support

Application Virtualization

Limited testing has been performed for Citrix XenApp 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

Desktop Virtualization (VDI)

Toad has been tested with Quest vWorkspace 7.6 running on Windows Server 2008 R2 64-bit.

Note: Toad may work in virtualization environments other than the ones in which it was tested.

User Requirements

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User, Vista standard user—on the computer.

If a Power User installs Toad, a Restricted User cannot do the following:

  • Associate file extensions.
  • View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start menu. As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place the shortcut on their desktop.

User Requirements and Restrictions for Running Toad

The following describes the requirements and restrictions for users who launch and run Toad:

  • To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security features.
 

Learn More

Support for This Product