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


VIENNA, VA - July 20, 2001 - FMS, Inc. has announced the immediate availability of Total SQL Analyzer™, the first comprehensive documentation and analysis solution for Microsoft SQL Server. User-friendly, even for those with limited knowledge of SQL Server, Total SQL Analyzer saves valuable time and hassles through its reliable documentation of all objects, properties, and settings available in SQL Server.

"As SQL Server applications grow in complexity, they become much harder to understand and manage," said Luke Chung, president and founder of FMS, Inc. "Total SQL Analyzer allows users to manage their SQL Server databases with confidence through an analysis of potential issues and performance bottlenecks. The extensive information provided empowers developers, even those who are in the process of learning and understanding SQL Server's power, to work more efficiently when creating new SQL Server applications or supporting applications created by others." 

Continuing in the FMS commitment to database innovation and quality, Total SQL Analyzer is the answer for those in the database community frustrated with the expense, time and errors associated with previous solutions that required users to document and analyze their SQL Server installation manually or with custom scripts. 

"I ran Total SQL Analyzer against our production database of over 100 tables, 300 views and 500 stored procedures, " said Arthur Fuller, chief developer of ETS Escape Routes Inc. "When it made it flawlessly through that chore, I gave it a monster database of over 400 tables, over 1000 stored procedures and 600 views. Not a hiccup. Just rock-solid performance and great reports. The only down side is that now I'm no longer indispensable to the company." 

"We were about to go live with our production database when I decided to run the Total SQL Analyzer Column Consistency report. I was shocked at what I found: many columns with similar names throughout our production database contained textual data but were defined with different lengths. There was a huge potential for data loss and for ASP pages to crash altogether when updating data. By using Total SQL Analyzer, I was able to quickly see this problem and modify our data structures. Crisis averted!" - Joe Pell, i9 Solutions

"Just by running Total SQL Analyzer on a client's heavily-taxed server, I discovered that not only was the lock timeout setting unchanged from its default (a potential contention problem), but the default max async io setting of 32 was also still in effect and was completely inappropriate for that machine's RAID subsystem. I ran TCP-B, reconfigured the server, and now it performs like it was meant to." - Brian Ford, Mirror Images

Implemented as a Windows-based application, Total SQL Analyzer gives developers the tool they need to create, deploy, and maintain SQL Server installations and provides a cost and time effective service offering:

  • Complete documentation of server configuration
  • Complete documentation of object schema
  • In-depth analysis of potential issues and performance problems
  • Over 70 presentation-quality reports that show clear and concise views of all generated information
  • Powerful documentation explorer
  • Jobs defined and re-run at any time
  • Job results saved over time
  • Support for all editions of SQL Server 7 and SQL Server 2000

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). Twenty-five licenses are available for an introductory price of $5,499 (regularly $6,999). 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

Founded in 1986, FMS is a private software development firm specializing in custom database applications. As the world's leading developer of support for Microsoft Access, Visual Basic and SQL Server, FMS has built long-term relationships with consumers, businesses, government agencies and education institutions in over 100 countries. Committed to innovation and quality, all FMS award-winning products are developed by a world-recognized team of in-house experts including Microsoft MVP's and undergo a rigorous quality assurance testing process. FMS is a Microsoft Certified Provider, a member of the Microsoft Independent Software Vender (MSDN ISV) and also a member of the Association for Competitive Technology.