Toad® for SQL Server

Add-on Modules

Xpert Tuning

The Xpert Tuning module supplements SQL Server tuning skills for IT professionals by stepping up their application tuning capabilities. The Xpert Tuning module also enables users to scan source code and then recommends several options to improve performance. The AutoTune feature further automates the tuning process by generating the SQL rewrites that offer the highest likelihood of improving your SQL statement. In addition to offering SQL tuning and schema change advice through the Xpert Tuning module, a new Index Simulator emulates the effects of creating an index with no impact to the target system. The new SQL Tuning component shortens tuning time for developers and DBAs, while ensuring better performing applications.

Benchmark Factory® for SQL Server Developer's Edition

Users can increase Toad for SQL Server’s power and flexibility with Benchmark Factory for SQL Server, to test user load on your SQL Server database. The integrated add-on (optional) is a highly scalable load testing, capacity planning and performance tuning tool. Benchmark Factory for SQL Server allows users to determine system capacity, pinpoint system bottlenecks and isolate system stress related problems in your SQL Server environment.

Toad Data Modeler

Quest Software's Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface into new or existing database structures. Toad Data Modeler enables users to reverse engineer over 20 different databases, design and generate SQL, create HTML or RTF reports, and generate data flow diagrams, in addition to versioning of database designs and creation of to-do lists.

• Database Design – Create high-quality database structures, generated automatically, following standard best practice design methodologies
• Documentation – Generate high-quality, detailed reports for documenting existing database structures
• Database Redesign – Take existing databases, re-design the model, and generate the new design SQL
• Database Migration – Generate out existing database structures to a new database platform for migration or copy to a different database