Total SQL Analyzer Pro - Sommario

Total SQL Analyzer Pro by FMS

URLs: fms-total-sql-analyzer-pro, fms total sql analyzer pro, fmstotalsqlanalyzerpro, 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

Provide comprehensive analysis for SQL Server.

Pricing: Total SQL Analyzer PRO V1.01.0025 1 Developer License, Total SQL Analyzer PRO V1.01.0025 5 Developer License, Total SQL Analyzer PRO V1.01.0025 1 Developer License - Upgrade from Standard 1 Developer License, Total SQL Analyzer PRO V1.01.0025 5 Developer License - Upgrade from Standard 1 Developer License, Total SQL Analyzer PRO V1.01.0025 5 Developer License - Upgrade from Standard 5 Developer License, Total SQL Analyzer Standard V1.0 1 Developer License, Total SQL Analyzer Standard V1.0 5 Developer License, Annual Premium Support Subscription 1 Support License, Annual Premium Support Subscription 1 Support License Renewal, Annual Premium Support Subscription 5 Support License, Annual Premium Support Subscription 5 Support License Renewal

Evals & Downloads: Read the Total SQL Analyzer help file, Read the Total SQL Analyzer PRO help file, Read the FMS License Agreement

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: Total SQL Analyzer PRO Standard Server analise query documentation database performance report

FMS

SQL query language

Part numbers: PC-511690-368328 511690-368328 PC-511690-368329 511690-368329 PC-511690-368334 511690-368334 PC-511690-368336 511690-368336 PC-511690-368335 511690-368335 PC-511690-368337 511690-368337 PC-511690-368338 511690-368338 PC-511690-368330 511690-368330 PC-511690-368331 511690-368331 PC-511690-368332 511690-368332 PC-511690-368333 511690-368333

Mfr. Part No: SQLA SQLA-5 SQLAP SQLAP-5 SQLAP-U SQLAP-U5