"No question this was one of the easiest transitions I have experienced due to the documentation you provide."
- R. Carter
Rave Reviews
|
|
|
|
|
Optimize Microsoft
SQL
Server
When using SQL Server or an Microsoft Access ADP, Total SQL Analyzer
PRO will help you analyze and document your SQL Server
resources.
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
For more information, read the Product Guide
|
|