Total SQL Analyzer Pro - Application - V1.0 - Summary
by FMS - Product Type: Add-In / Application
Summary
Total SQL Analyzer Pro - Application - V1.0 by FMS
Provide comprehensive analysis for SQL Server. Total SQL Analyzer provides comprehensive, easily-navigated analysis for SQL Server. Total SQL Analyzer examines SQL Server configurations and designs to detect over 95 issues in your servers and databases. Total SQL Analyzer works across an unlimited number of servers, while saving an unlimited number of analyses for each server for developers' future reference. These results represent an audit trail of configuration, schema, and the state of a Microsoft SQL Server system over time.
Total SQL Analyzer is available in 2 editions:
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 Standard generates the same documentation and reports as the PRO version, but does not include the performance and issue analysis or the interactive dependency diagrams
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
enerate 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
Other Features include:
Implemented as Windows-based applications
Complete documentation of server configuration
Complete documentation of object schema
Jobs defined and re-run at any time
Job results saved over time
Support for all editions of SQL Server 7 and SQL Server 2000
PartNumbers: PC-511690-22153 511690-22153 PC-511690-22154 511690-22154 PC-511690-23833 511690-23833 PC-511690-23907 511690-23907 PC-511690-23888 511690-23888 PC-51169000-A 51169000-A PC-51169000-B 51169000-B
Publisher PartNumbers: SQLA SQLA-5 SQLAP SQLAP-5 SQLAP-U SQLAP-U5
PurchaseOptions: Total SQL Analyzer PRO V1.01.0025 1 User License , Total SQL Analyzer PRO V1.01.0025 5 User License , Total SQL Analyzer PRO V1.01.0025 1 User License - Upgrade from Standard 1 User License , Total SQL Analyzer PRO V1.01.0025 5 User License - Upgrade from Standard 1 User License , Total SQL Analyzer PRO V1.01.0025 5 User License - Upgrade from Standard 5 User License , Total SQL Analyzer Standard V1.0 1 User License , Total SQL Analyzer Standard V1.0 5 User License
Resources: Read the Total SQL Analyzer help file, Read the Total SQL Analyzer PRO help file, Download the Total SQL Analyzer Pro V1.0 evaluation on to your computer - Expires After 30 Days
Operating System for Deployment: Windows ME, Windows 2000, Windows 98, Windows NT 4.0
Architecture of Product: 32Bit
Product Type: Add-In, Application
Compatible Containers: Microsoft SQL Server 2000, Microsoft SQL Server 7.0
Product Class: Component Development Tools
Keywords: SQL query language FMS Author Total SQL Analyzer PRO Standard Server analise query documentation database performance report
