Total SQL Analyzer Pro for SQL Server 7.0/2000

FMSDatabase Documentation Tools
Version 1.01.0025 (Apr 9, 2003)

Analyze and document SQL Server for improved performance and reliability.

  • Detects over 120 performance and design issues in SQL Server.
  • Generates interactive dependency diagrams and comprehensive reports.
  • Saves historical analysis for tracking configuration changes over time.
FMS logo

Prices from:

Loading...
Available individuallyOur Price
Total SQL Analyzer Pro for SQL Server 7.0/2000Loading
Provide comprehensive analysis for SQL Server.
Total SQL Analyzer Pro for SQL Server is a Windows-based software component designed to analyze Microsoft SQL Server and 2000 installations. It evaluates server configurations and database schemas, identifies potential performance bottlenecks and design problems, and produces detailed documentation along with interactive object dependency diagrams. This solution helps database administrators and developers gain insights into server performance and maintainability efficiently.

Comprehensive Performance and Configuration Analysis

Scans SQL Server objects and settings to detect over 120 potential issues affecting performance and scalability, including server, database, table, view, stored procedure, and user-defined function configurations.

Best Practices and Design Issue Detection

Identifies design flaws such as tables without primary keys, inconsistent data types, and improper handling of null values, promoting adherence to industry-accepted best practices for maintainability and reliability.

Interactive Object Dependencies Diagram

Visualizes and navigates dependencies among tables, views, stored procedures, functions, triggers, and constraints, helping users understand object relationships within the database.

Extensive Documentation and Reporting

Generates over 70 presentation-quality reports detailing schema, configurations, performance tips, and issues. Reports can be printed or exported to HTML and Microsoft Word formats.

Documentation Explorer Interface

Provides a Windows Explorer-style interface to browse, filter, and compare object properties, performance tips, and issues with support for consistency checking across objects.

Job Scheduling and Management

Enables definition and execution of customizable analysis jobs specifying servers and objects, with support for saving results over time and scheduling for off-peak execution times.

Audit Trail and Change Tracking

Automatically saves analysis results from each job run, allowing users to monitor configuration and schema changes across multiple servers for troubleshooting and disaster recovery.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Host Application

  • SQL Server
  • Visual Studio