What is SQL_ConfigSPY?

 

Note: An updated version of SQL_ConfigSPY has been uploaded in the download section which addresses re-configuration issue to override changes.

 

SQL_ConfigSPY (from www.sqlcommunity.com) tool can do a thorough configuration check of your SQL Server in just few seconds. It helps you eliminate the amount of time spent on checking the configuration of your SQL Server. Based on the research, SQL_ConfigSPY has saved 3-5 hours of manual work by a DBA.

 

Ops_ConfigSPY will check the following and generate an HTML report that can be used for Disaster Recovery, Inventory Control or Server Rebuild.

üÂWhich users have server level access of your SQL Servers

üÂOrphan Windows & SQL Server logins from your SQL Server

üÂThe current SQL Server configuration settings for your database server (A-Z)

üÂConfiguration settings of Surface Area Configuration (SAC)

üÂIdentify If /3GB switch configured in boot.ini

üÂCollation of your SQL Server

üÂDefault instance name of your SQL Server

üÂWhen your SQL Server service was last recycled

üÂService accounts on which your SQL Server/Agent service is running

üÂIf SQL Server services are set to start automatically during boot

üÂHow much physical memory does your server have? And how much is allocated to SQL Server

üÂHow many processors does your SQL Server box have and what type of processor are they

üÂThe Installed location of SQL Server and identify the current service pack/build number installed on the server

üÂHow many databases do you have any what are they

üÂWho the owners of each databases are

üÂDatabase level properties currently configured on all the databases

üÂTrace flags that are currently set on the server

üÂSET options that are currently set at the server level

üÂDatabases that are being backed up and their location

üÂSpeed of your backup process and what’s their sizes and when the last successful backup was taken

üÂList of SQL Agent jobs and their creation dates and their current status? (enabled / disabled)

üÂJob owners and steps for each jobs and how many times those job have failed (based on available job history).

üÂList of DTS/SSIS packages you have and their owners and creation dates

üÂSpace usage for System and User databases form all drives and current free space on those drives

üÂHow much total data/log space is being used by SQL Server on the server

üÂDatabaseÂdetails including their data/log file locations, size, auto-growth settings, max size and logical name details

 

And much more will be checked in just few seconds…