Comprehensive Documentation & Analysis for SQL Server!

Relax, You're In Control!

This product guide is designed to show you how Total SQL Analyzer can reduce your SQL Server development time, and improve the quality and performance of your applications.

Is Total SQL Analyzer Right for You?

Total SQL Analyzer provides many benefits for developers who are tasked with creating applications that use SQL Server. Whether you develop against SQL Server using Visual Basic, Access, Active Server Pages, or any other compatible environment, Total SQL Analyzer provides you with the complete picture of your servers and databases. Total SQL Analyzer also provides invaluable benefits to database administrators who are tasked with configuring and maintaining SQL Server installations.

Total SQL Analyzer is specifically designed to reduce your project development time by providing detailed documentation and analysis of SQL Server servers and databases. How does this directly help you? Read on to learn more.

Quickly Understand the Big Picture with Top-Level Summary Reports

If you develop applications in today's rapid-pace world, your number one concern is meeting your deadlines. Total SQL Analyzer provides specific concrete benefits that help you meet your goals.

One of the key problems in developing with SQL Server is that, as your applications grow, it can be difficult to see the forest for the trees. You need to see the big picture in order to make top-level decisions about design and work loads. Total SQL Analyzer provides targeted summary reports to give you exactly this information.

Understand Individual Objects with Drill-Down Detail Reports

The second important problem with SQL Server is that you need detailed information about specific objects. Total SQL Analyzer allows you to drill down to the lowest level to see how tables, views, stored procedures and other objects are actually constructed. This low-level information can dramatically reduce your development time by providing you with a roadmap that helps you write your applications faster.

Get Up-to-Speed Quickly on Inherited Projects

If you haven't already inherited someone's SQL Server project, chances are that you will soon. Getting up to speed with an application that is already in development or production can be time consuming. Navigating through objects and settings is a manual process that can add weeks or months to your development timeline.

Total SQL Analyzer can condense those weeks and months into hours and days. Because Total SQL Analyzer provides you with complete documentation and analysis of server and database design, you can see exactly what is happening on, and get up-to-speed quickly.

Deliver More Reliable Applications by Detecting Errors and Omissions

Your mandate as a developer is a tough one: not only are you expected to deliver applications on a tight schedule, you are expected to deliver solutions that perform quickly and have few errors. Unfortunately, the task of digging through SQL Server to detect performance problems, data inconsistencies, and potential errors is a long arduous process. Let Total SQL Analyzer do the work for you.

Total SQL Analyzer scans all server and database objects and properties to detect hidden performance problems. Performance problems can occur when properties are set to non-optimal values, or default server settings are not modified to reflect how your applications work. Now you can find these potential issues in minutes instead of days.

Even simple SQL Server installations can contain object definitions and property settings that may cause errors in your applications. Total SQL Analyzer checks objects and settings against a database of known potential errors and omissions.

Ensure Data Consistency and Integrity

As tables and fields multiply, the chance for mismatched data types increases. A simple matter of a key field duplicated in a child table with a different data type can lead to data inconsistencies and possible data loss or corruption. Mapping data types between fields with the same names across tables is the only way to find these consistency issues. Total SQL Analyzer does this for you automatically, by providing documentation of field data types across objects and showing inconsistent data types.

Other consistency and integrity issues arise when property values differ among related objects. For example, if you have multiple tables that all deal with an OrderID field, you should ensure that the property values are consistent across all instances of the field. Total SQL Analyzer solves this problem for you by providing reports of property values across objects.

We Guarantee Total SQL Analyzer Will Save You Time and Money

As you can see from the benefits above, we created Total SQL Analyzer to specifically address the issues that affect you most. We absolutely guarantee that Total SQL Analyzer will:

• Reduce your development time.
• Increase your application's quality, performance and scalability.
• Pay for itself in the first week on the job.

If you find that Total SQL Analyzer doesn't exactly meet your needs, return it within 30 days for a complete refund.

Detailed Product Facts

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 along with the 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, therefore, 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.

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 Does Total SQL Analyzer Work?

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

You run the job after you define it. 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.

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

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.