Showing posts with label Best Practices Analyzer. Show all posts
Showing posts with label Best Practices Analyzer. Show all posts

Friday, April 6, 2012

Microsoft SQL Server 2012 Best Practices Analyzer

Microsoft SQL Server 2012 Best Practices Analyzer is a diagnostic tool that gathers information about all the SQL Server 2012 components installed on the system and determines if the configurations are setup according to the recommended best practices.

It indicates potential problems with the SQL Server installation and recommends a solution.

You can download the tool from here

The pre-requisites are:

System requirements
Supported operating systems: Windows 7, Windows Server 2008, Windows Server 2008 R2


The following are required for using SQL Server 2012 Best Practices Analyzer (BPA):
PowerShell V2.0
Microsoft Baseline Configuration Analyzer V2.0

I tried installing BPA on my Windows 2008R2 development environment and it prompted me with this message: “Microsoft Baseline Configuration Analyzer 2.0 is not installed….”

Require_Baseline_Configuration_Analyzer2

So, I went ahead and installed the Baseline Configuration Analyzer 2.0

Install_Baseline_ConfigV2

After that the BPA setup completed with no problem:

Install_BPA_Analyzer

Here is a real quick video of SQL Server BPA in action:

Microsoft SQL Server 2012 Best Practices Analyzer in action