SQL SERVER – Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

Today (May 5, 2011) I will be presenting on Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer at http://zeollar.com/. I will be presenting on following subjects.

The tools which I will be using in the demonstration are following:

  • Engine – Backups outdated for databases
  • Engine – Database files and backups exist on the same volume
  • Engine – SQL Server tempdb database not configured optimally
  • Engine – Authentication Mode
  • Engine – Database consistency check not current
  • Engine – Databases using simple recovery model

Microsoft Baseline Configuration Analyzer 2.0

Microsoft Baseline Configuration Analyzer 2.0 (MBCA 2.0) can help you maintain optimal system configuration by analyzing configurations of your computers against a predefined set of best practices, and reporting results of the analyses.

Microsoft® SQL Server® 2008 R2 Best Practices Analyzer

The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions:

  • Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server
  • Determines if the configurations are set according to the recommended best practices
  • Reports on all configurations, indicating settings that differ from recommendations
  • Indicates potential problems in the installed instance of SQL Server
  • Recommends solutions to potential problems

Reference: Pinal Dave (http://blog.SQLAuthority.com)

2 thoughts on “SQL SERVER – Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

  1. Pingback: SQL SERVER – Video – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer « Journey to SQLAuthority

  2. I downloaded Microsoft Baseline Configuration Analyzer 2.0 and installed in Microsoft Window Server 2008 R2 Enterprise

    I have Microsoft Window Server 2008 R2 Enterprise that install SQL Server 2008 R2.
    Then, I download and installed the Microsoft Baseline Configuration Analyzer 2.0.

    The MBCA cannot connect to local or remote SQL Server.

    Note: I configured my SQL Server 2008 R2 as follow:

    VM-Machine01\SP2010 on port 5555.

    Can someone please help on this?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s