Total SQL Analyzer PRO

Super-Charge SQL Server

SQL Analyzer Info:

Why SQL Analyzer?


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

- R. Carter

Rave Reviews

Additional Info:



Microsoft SQL Server documentation program Download the trial version of the premier Microsoft Access documentation program

Press Release


First comprehensive documentation and analysis solution for Microsoft® SQL Server

VIENNA, VA - May 8, 2001 - FMS, Inc. is pleased to introduce Total SQL Analyzer release candidate, the first comprehensive documentation and analysis solution available for Microsoft SQL Server. Total SQL Analyzer allows developers and database administrators to keep track of their SQL Server installations by providing comprehensive documentation of all objects, properties, and settings available in SQL Server, along with analysis of potential issues and performance bottlenecks. A functional release candidate version of Total SQL Analyzer is available from the FMS web site at

The Total SQL Analyzer Solution

The ability to document all aspects of SQL Server is crucial to maintaining a reliable and scalable enterprise database system, but until now, no solutions other than custom scripts and procedures have been available. Such custom solutions are costly, often incomplete, and seldom up to date, which forces many developers and database administrators to rely on backups or dig through hundreds of dialogs in the SQL Server Enterprise Manager to solve configuration and schema issues. Total SQL Analyzer solves these problems by giving developers the “big picture” as well as detailed analysis about their database installations.

Features Summary

Implemented as a Windows-based application, Total SQL Analyzer gives developers the tools they need to create, deploy, and maintain SQL Server installations:

  • Provides complete documentation of server configuration
  • Provides complete documentation of object schema
  • Generates in-depth analysis of potential issues and performance problems
  • Offers over 70 presentation-quality reports that show clear and concise views of all generated information
  • Features a powerful documentation explorer
  • Jobs can be defined and re-run at any time
  • Job results can be saved over time
  • Supports all editions of SQL Server 7 and SQL Server 2000
  • Total SQL Analyzer is certified Windows 2000 Compatible

“Building on our experience of creating leading-edge database developer tools for over a decade, we’re extremely proud to release our first product for Microsoft SQL Server,” said Luke Chung, president and founder of FMS, Inc. “Total SQL Analyzer provides the information SQL Server developers and system administrators need to take control of their applications and understand their inner workings. The documentation and analysis it generates significantly simplifies the complexity of SQL Server application deployment and maintenance.”

Licensing and Pricing

Total SQL Analyzer is licensed on a per developer basis. Single license is available for the introductory price of $399 (regularly $499). A 5-license package is available for the introductory price of $1,299 (regularly $1,499). Larger quantity discounts are available by contacting FMS, Inc. Total SQL Analyzer can be purchased directly from FMS, through most corporate resellers, and international distributors. All FMS products offer a 30-day money back guarantee.

About FMS

Celebrating its 15th year in business, FMS, Inc. is a privately held software development firm and one of the world’s leading providers of database development solutions for Microsoft Access, Office, Visual Basic and SQL Server. FMS currently offers 14 products for developers and database administrators, including award-winning source code libraries, data analysis programs, and database maintenance utilities. Serving 90 of the Fortune 100 firms, FMS products are used by tens of thousands of customers in over 100 countries. Experts in the Microsoft Access, Visual Basic, and SQL Server communities, FMS developers have written articles and books, and speak frequently at conferences and user group meetings throughout the United States and Europe including major Microsoft sponsored events such as TechEd, Professional Developers Conference, Advisor DevCon, and Microsoft Office and VBA Solutions conferences. FMS is a Microsoft Certified Solution Provider and a member of the Microsoft Independent Software Vendor (MSDN ISV) and Microsoft Component Builders programs. FMS is also a member of the Software & Information Industry Association.