Quickly validating sql server configuration settings

Database Administrators are often asked questions like "are all the SQL Servers within the organization configured according to industry standards?

The BPA tool basically uses a predefined set of SQL Server 2012 recommendations and best practices to identify potential issues within the database environment.

You can download the latest version of Microsoft SQL Server 2012 Best Practices Analyzer (BPA) for free from the following link.

The following are required for using SQL Server 2012 Best Practices Analyzer: Power Shell V2.0 Microsoft Baseline Configuration Analyzer V2.0 Prior to the installation of Microsoft SQL Server 2012 Best Practice Analyzer you need to download and install Microsoft Baseline Configuration Analyzer 2.0 otherwise you will see the below screen when you double click SQL2012BPA_Setup64. MSI based on your environment when trying to install Microsoft SQL Server 2012 Best Practice Analyzer.

Next, click Connect to Another Computer and choose Local Computer and then click OK to close the "Connect to Another Computer" window.

Then in the Microsoft Baseline Configuration Analyzer 2.0 window, click Start Scan to begin the scan.

In the Microsoft Baseline Configuration Analyzer 2.0 Enter Parameters screen, you need to specify the SQL Server Instance Name, for a default instance you need to specify the instance name as MSSQLSERVER and for a Named Instance you need to specify the SQL Server Instance Name as shown in the below snippet.

Using Microsoft SQL Server 2012 Best Practice Analyzer you can scan the SQL Server Database Engine, Analysis Services, Replication, Integration Services, Reporting Servers and SQL Server Setup.

You can choose the required parameters and click the Start Scan at the bottom of the screen to begin the scan.

Once the Microsoft SQL Server 2012 BPA 1.0 has completed the scanning you will be able to see the Baseline Configuration Analyzer Report which will be categorized into Errors and Warnings as shown in the snippet below.

Tags: , ,