About

This is the site for utility MSSQLServerAuditor. The purpose of the utility is to make the complete audit of the running MS SQL server and provide the details analysis about the most important aspects of the MS SQL server.

It is important, that no permanent database objects on the inspected MS SQL instance are created during the audit procedure. The utility is designed to run on production system and can be configure to affect on the running SQL server as minimum as it possible.

Internally, it is a .Net program, written on C# and running under MS Windows. Currently 32 and 64-bit Windows (desktop versions 7,8 and Server platforms MS Windows 2008, 2012) with .Net 4.5.x are supported. The supported versions of MS SQL servers are: 2000, 2005, 2008, 2008 R2, 2012 and 2014. The utility running in the read only-mode and check many aspects the MS SQL Server. As a result, the set of reports about detected issues are provided.

It is expected, that based on the results of the audit, the qualified database administrator may create the recommendations to resolve the issues and problems, found by the utility. The typical scenario could be the followings:

MSSQLServerAuditor.UsageScenario