Quick Find:

Search for:

 Total SQL Analyzer PRO

 

Super-Charge
SQL Server

SQL Analyzer PRO Info:
Product Guide
Rave Reviews
FAQs
 Get SQL Analyzer PRO:

Convince Your Boss

Check for Updates

License Terms

 
 
 
"No question this was one of the easiest transitions I have experienced due to the documentation you provide." - R. Carter
 
 

 

 

Product Fact Sheet
This document describes all aspects of Total SQL Analyzer in detail.

Contents

Introduction
What Does Total SQL Analyzer Document?
How Total SQL Analyzer Works
List of Included Reports
Analysis Performed
System Requirements and Supported Platforms
Included Documentation
Purchasing and Pricing
Contacting FMS

 

Introduction

Whether you are a developer writing applications for Microsoft SQL Server, or a database administrator responsible for maintaining one or more Microsoft SQL Server installations, the problem is clear: how do you keep track of your Microsoft SQL Server installations?

Total SQL Analyzer offers the single best solution to this problem by providing the industry's first comprehensive documentation and analysis solution for Microsoft SQL Server. Total SQL Analyzer provides comprehensive documentation of all objects, properties, and settings available in Microsoft SQL Server, along with analysis of potential issues and performance bottlenecks.

Implemented as a Windows-based application, Total SQL Analyzer includes the following top-level functionality:

  • Create Jobs that define the server and which objects, and options you want. Job definitions are saved and run on demand or deferred to non-peak times through our scheduling tools. 
  • Documentation and Analysis results are automatically saved, allowing chronological reviews of changes and additions to the server. 
  • Over 70 presentation-quality reports ranging from concise summaries to detailed listings of objects and properties. You can print reports or export them to Microsoft Word or HTML. 
  • Issue and Performance Analysis provide you with the information you need to find hidden problems and performance bottlenecks.

Most importantly, Total SQL Analyzer provides the complete documentation and analysis solution you need to create, debug, deploy, and support Microsoft SQL Server installations. 

What Does Total SQL Analyzer Document?

Total SQL Analyzer provides complete and comprehensive documentation and analysis for Microsoft SQL Server installations.

Object Documentation

Total SQL Analyzer provides comprehensive documentation of Microsoft SQL Server and its objects and settings.

Property Documentation

Total SQL Analyzer documents every property of every object you select. The program uses SQL DMO to retrieve property values. In addition, Total SQL Analyzer reads other information about objects that aren’t part of the standard property collections. For example, Total SQL Analyzer can document all registry settings for your Microsoft SQL Server installation. Although registry settings aren’t actual properties, and aren’t available through the Microsoft SQL Server Enterprise Manager, they represent important information, so Total SQL Analyzer includes them.

Analysis

While it is generating object and property documentation, Total SQL Analyzer analyzes objects to provide detailed analysis of objects that go beyond just documentation. Total SQL Analyzer includes two types of analysis.

  • Issue Analysis includes items in your database that may be potential problems. See the help file for a complete list of issues that Total SQL Analyzer detects.
     
  • Performance Analysis includes items, property settings and designs that may lead to performance problems. See the help file for a complete list of performance issues that Total SQL Analyzer detects.

How Total SQL Analyzer Works

Total SQL Analyzer is designed to balance ease of use with comprehensive documentation and analysis. We have designed the program using concepts that should be familiar to you if you have used Microsoft SQL Server in general, and Microsoft SQL Server Enterprise Manager in particular.

To get an idea of how Total SQL Analyzer works, look at the following steps.

Step 1: Define a Job

Before Total SQL Analyzer can provide documentation and analysis, you need to specify the server you want to document, and which objects you want to include. To do this, you create a new Job.  Jobs contain information about the server, object selections, and options you specify to control additional information collected in a Job Result. To make Job creation easy, Total SQL Analyzer includes a New Job Wizard that steps you through each part of the process.

Step 2: Run the Job

After you have defined your Job, you run the Job. This process generates documentation and analysis into Job Results files that are stored on disk. Total SQL Analyzer provides a Run Job tool that allows you to run Jobs immediately, or schedule them for a later time.

Step 3: View the results

After the Job run is complete, you have a Job Results file. You can use the Documentation Explorer built into the program to navigate through all documented objects and see properties, settings, and analysis results.

Step 4: Use Reports

Once you have viewed the results, you will probably want to print or export documentation and analysis data. Total SQL Analyzer provides a Report tool that makes it easy to select, preview, print, and export any of over 70 reports. You can also customize various aspects of the reports.

Step 5: Set up a schedule to run Jobs on a regular basis.

One of the most valuable features of Total SQL Analyzer is the ability to run any Job multiple times. This is useful when you want to maintain documentation of your Microsoft SQL Server installations over time. Total SQL Analyzer allows you to run any Job any number of times, and have the Job Results stored in different files.

List of Included Reports

Total SQL Analyzer includes more than 70 presentation quality reports. Reports can be previewed, printed, or exported to Word or HTML formats. The following table lists all reports available in Total SQL Analyzer.

Server Reports

Non-Database Scripts Report, Sorted by Object Type

Sorted by Object Type

Server Properties

Sorted by Property Name

Server Summary

Sorted by Property

Server Role Reports

Server Role Properties

Sorted by Server Role

Database Reports

Database List

Sorted by Database Name

Database Object Inventory

Sorted by Database and Object

Database Properties and Settings

Sorted by Property Name

Database Scripts, Sorted by Database

Sorted by Database

Table Columns, Sorted by Database and Column Name

Sorted by Database and Column

Database Role Reports

Database Role Properties

Sorted by Role

Stored Procedure Reports

Stored Procedure List with T-SQL

Sorted by Procedure

Stored Procedure Properties

Sorted by Procedure

Stored Procedure Properties

Sorted by Property Name

Table Reports

Table Checks

Sorted by Table Name

Table Column Properties

Sorted by Property Name

Table Column Properties

Sorted by Table and Column

Table Columns

Sorted by Column and Table

Table Columns

Sorted by Table

Table Dictionary

Sorted by Table Name

Table Dictionary with Column Properties

Sorted by Table Name

Table Index Properties

Sorted by Property Name

Table Index Properties

Sorted by Table

Table Indexes

Sorted by Table and Index

Table Key Properties

Sorted by Property Name

Table Key Properties

Sorted by Table

Table Keys

Sorted by Table

Table List

Sorted by Table Name

Table Properties

Sorted by Property Name

Table Properties

Sorted by Table Name

Table Trigger Properties

Sorted by Property Name

Table Trigger Properties

Sorted by Table and Trigger

Table Triggers

Sorted by Table

View Reports

View List with T-SQL

Sorted by View

View Properties

Sorted by Property Name

View Properties, Sorted by View Name

Sorted by View

Transaction Log Reports

Transaction Log Log File Properties

Sorted by Log File

Transaction Log Properties

Sorted by Transaction Log

Backup Device Reports

Backup Device List

Sorted by Property Name

Backup Device Properties

Sorted by Device Name

Defaults Reports

Default Properties

Sorted by Default

File Group Reports

File Group Properties

Sorted by File Group

Full Text Reports

Full Text Catalog Properties

Sorted by Full Text Catalog

Full Text Service Properties

Sorted by Property Name

Issues Reports

Column Consistency Report

Sorted by Column and Table

Issues and Performance Tips

Sorted by Item

Issues and Performance Tips

Sorted by Object Type

Language Reports

Language Properties

Sorted by Language

Linked Server Reports

Linked Server List

Sorted by Linked Server

Login Reports

Full Text Catalog Reports

Sorted by Login

Remote Server Reports

Remote Server Properties

Sorted by Remote Server

Replication Reports

Replication Database Properties

Sorted by Database

Replication Distributor Properties

Sorted by Property Name

Replication Properties

Sorted by Property Name

Replication Publisher Properties

Sorted by Property Name

Replication Subscriber Properties

Sorted by Property Name

Rule Reports

Rule Properties

Sorted by Rule

SQL Agent Reports

Job Server Job Steps

Sorted by Job

SQL Agent Alert Categories

Sorted by Category

SQL Agent Alert System

Sorted by Property Name

SQL Agent Alerts

Sorted by Alert

SQL Agent Job Categories

Sorted by Category

SQL Agent Job Properties

Sorted by Job

SQL Agent Job Schedule

Sorted by Job

SQL Agent Operator Categories

Sorted by Category

SQL Agent Operators

Sorted by Operator

SQL Agent Properties

Sorted by Property Name

SQL Agent Target Server Groups

Sorted by Target Server Group

SQL Agent Target Servers

Sorted by Target Server

System Reports

List of Issues and Performance Tips

Sorted by Item

List of Jobs

Sorted by Job

List of Reports

Sorted by Object Type

System Data Type Reports

System Datatype Properties

Sorted by System Datatype

User Reports

User Properties

Sorted by User

User Defined Data Type Reports

User Defined Datatype List

Sorted by User Defined Datatype

User Defined Datatype Properties

Sorted by User Defined Datatype

User Defined Function Reports

User Defined Function Properties

Sorted by Function

User Defined Function Properties

Sorted by Property Name


Analysis Performed

Total SQL Analyzer analyzes Microsoft SQL Server schema and configuration information to detect issues and performance problems.

Issues Detected

  • ANSI Nulls setting is off (Server)
     
  • Lock Timeout set to default (Server)
     
  • Max Asynchronous IO set to default (Server)
     
  • Model database size larger than remaining free disk space on server (Server)
     
  • "sa" user with no password (Server)
     
  • Sum of all database max sizes exceeds server hard disk size (Server)
     
  • Column consistency issues (Server)
     
  • Database and transaction log share physical drive (Database)
     
  • Database compatibility level different than server version (Database)
     
  • Database has multiple owners (Database)
     
  • Database name contains spaces (Database)
     
  • Trigger disabled (Table)
     
  • Check constraint disabled (Table)
     
  • ANSI Nulls Status is False (Stored Procedure)
     

Performance Problems Detected

  • Allow updates turned on (Server)
     
  • Temp database located on server's data drive (Server)
     
  • Auto update statistics turned on (Database)
     
  • Auto shrink turned on (Database)
     
  • Database not read-only (Database)
     
  • Text/ntext columns found (Table)
     
  • AllowNulls turned on in column (Table)
     
  • Varchar, nvarchar, varbinary columns found (Table)
     
  • Primary key based on float or real column (Table)
     
  • Database file growth increment set to default of 10% (File Group)
     
  • Log file growth increment set to default of 10% (Transaction Log)
     

System Requirements and Supported Platforms

This section covers the technical aspects of the Total SQL Analyzer product.

Supported Platforms

Total SQL Analyzer supports the following:

  • All editions of Microsoft SQL Server 2000
     
  • All editions of Microsoft SQL Server 7

Operating systems supported are:

  • Windows 98/ME
     
  • Windows NT 4.0 and later
     
  • Windows 2000

System Requirements

Total SQL Analyzer has the following system requirements:

  • Microsoft Windows 98, Windows 98 Second Edition, Windows ME, or Windows 2000
     
  • Pentium 300 MHZ processor (minimum)
     
  • 64 MB RAM minimum, 128 suggested
  • Windows NT 4.0 and later
     
  • 35 MB free disk space required for installation. Additional disk space is required for storage of Jobs and Job Results

Included Documentation

Total SQL Analyzer comes with the following documentation:

  • a complete 100-page printed user guide
     

  • context-sensitive online help covering all program topics

Purchasing and Pricing

 

This section contains information on purchasing and pricing.

 

Total SQL Analyzer PRO Pricing
for SQL Server

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.
See the Comparison Chart
 

Total SQL Analyzer PRO

Licenses

SQL Server 2000
SQL Server 7.0


Single

$999

5 Seat

$2,999

Upgrade Single

$599

Upgrade 5 Seat

$1,799

Total SQL Analyzer

Single

$499

5 Seat

$1,499

Premium Support Subscription
Single License

$ 299

5 Seat License

$ 999

More Information  
Licensing Information
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. Read the License Agreement for full licensing rules.

 

 

Contacting FMS

 

For more information, sales assistance, or to place an order, please contact FMS:

 

FMS Inc.

8150 Leesburg Pike, Suite 600

Vienna, VA 22182   USA

Phone: 703-356-4700

Fax: 703-448-3861

Toll Free: 1-888-220-6234

Email: sales@fmsinc.com

Web: www.fmsinc.com

 

 

Contact Us  l   Web questions: Webmaster   l   Copyright 2010 FMS, Inc., Vienna, Virginia

Celebrating 24 Years of Software Excellence
 
Last modified: July 15, 2010