Trial Version
A Trial version is available for download from Grey Matter's website.
This demo program lets you explore how Total SQL Analyzer works and the output it generates. It includes documentation of a sample database, and allows you to see the large variety of results generated by Total SQL Analyzer.
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 70 well-structured, filterable reports for all schema and properties which can be printed or saved as HTML and MS Word format
Trial Version
A Trial version is available for download from Grey Matter's website.
This demo program lets you explore how Total SQL Analyzer works and the output it generates. It includes documentation of a sample database, and allows you to see the large variety of results generated by Total SQL Analyzer.
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.
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.
Total SQL Analyzer PRO can generate a thorough, easily-navigated analysis with the click of a mouse. There is no way a developer or database administrator can accomplish this without spending hundreds of hours of effort on the analysis of one server, and it just would not be economically feasible. Total SQL Analyzer PRO can provide this information for an unlimited number of servers and can save an unlimited number of analyses for each server. These results represent an audit trail of configuration, schema, and the state of a Microsoft SQL Server system over time. This kind of information is invaluable for pinpointing scalability problems, to aid in disaster recovery, and for many other purposes.
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.