This
document describes all aspects of Total SQL Analyzer in detail.
Contents
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:
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
|
