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 . 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 (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Cartoon Challenge – 140 Character Winner is Here
Next Post
SQL SERVER – Video – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

Related Posts

2 Comments. Leave new

  • Edwin Tjhai
    May 6, 2011 9:58 pm

    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?

    Reply

Leave a Reply Cancel reply

Exit mobile version