MSSQLServerAuditor

MSSQLServerAuditor is a utility MSSQLServerAuditor performs a comprehensive audit of your running MS SQL server and checks the most important aspects of server operation and configuration. It reveals configuration and configuration problems, security problems and performance problems. Based on the audit results recommendations are given to solve the problems found.

Supported versions of MS SQL Servers: 2000, 2005, 2008, 2008 R2, 2012 and 2014. The utility works in read-only mode and no permanent database objects are created during the audit procedure.

The key features of the MSSQLServerAudit utility are as follows:

• The application does not require other programs (e.g. MS SQL Management Studio)
• The utility can connect to multiple instances of MS SQL Server simultaneously and generate summary reports on a single page.
• All the information collected during the MS SQL instance audit is stored in an external SQLite database.
• The audit is performed in multiple threads, but the number of simultaneous queries is limited to minimize the impact on MS SQL Server.