Quick Find: Search for:

 Total SQL Analyzer PRO

 

Super-Charge
SQL Server

SQL Analyzer PRO Info:
Product Guide
Rave Reviews
FAQs
 Get SQL Analyzer PRO:

Convince Your Boss

Check for Updates

License Terms

 
 
 
"No question this was one of the easiest transitions I have experienced due to the documentation you provide." - R. Carter
 
 

 

Total SQL Analyzer PRO for Optimizing SQL Server

Improve performance and scalability
Automatically detect over 95 potential performance problems in your servers and databases.

Improve reliability and maintainability
Pinpoint over 25 design problems and ensure you adhere to industry-standard best practices.

Develop faster
See dependencies among objects with our interactive dependency browser. Knowing what is used makes development much faster.

Understand and manage your project
Generate comprehensive documentation of your server and objects--over 80 presentation quality reports.

Key Features and Benefits
 

Improve performance and scalability
Automatically detect over 95 types of specific performance issues in your servers and databases.
Specific optimization tips are generated for any queries that could benefit such as missing indexes, SELECT *, etc.
Identify Tables without clustered indexes.
Locate cursor usage
Find column data types that can be optimized.
Plus many more
Improve reliability and maintainability
Automatically detect over 25 types of issues that may affect SQL Server reliability and maintainability.
Identify design problems and suggests best practices. 
Detect tables without primary keys
Find handling of null values that do not confirm to ANSI specifications
Locate identically named columns among all tables with different data types. 
Develop Applications Faster
See dependencies among objects that can be printed or saved in HTML or MS Word format.
View interactive diagrams showing where objects are used and the objects used by other objects. 
See where tables are used by views, stored procedures and user-defined functions. 
See which tables, views and user-defined functions are used by a given stored procedure.
Understand and Manage Your Project
Generate comprehensive documentation. 
Powerful Documentation Explorer to browse, filter and compare object properties. 
Snapshot of all object scripts is saved and can be viewed. 
Audit trail of configuration changes to servers and database over time.
Audit trail of configuration changes to a server over time.
Over 80 well-structured, filterable reports for all schema and properties which can be printed or saved as HTML and MS Word format

To Learn More

See the Comparison Chart

Total SQL Analyzer PRO Pricing
for SQL Server

Two editions are available:
Total SQL Analyzer PRO is the complete solution for SQL Server. It includes all features, including performance analysis, issue detection, interactive dependency diagrams, documentation, and reports.

Total SQL Analyzer generates the same documentation and reports as the PRO version, but does not include the performance and issue analysis or the interactive dependency diagrams.
See the Comparison Chart
 

Total SQL Analyzer PRO
Licenses

SQL Server 2000
SQL Server 7.0
Single

$999
5 Seat

$2,999
Upgrade Single

$599
Upgrade 5 Seat

$1,799

Total SQL Analyzer

Single

$499
5 Seat

$1,499
Premium Support Subscription
Single License

$ 299
5 Seat License

$ 999
More Information  
Licensing Information
Total SQL Analyzer PRO and Total SQL Analyzer are licensed on a per user basis. Each person who runs the program must own a product license. Read the License Agreement for full licensing rules.
Runtime/Redistributable Version
Not Available
Questions  l   Web questions: Webmaster   l   Copyright © 2008 FMS, Inc.

Celebrating 21 Years of Software Excellence