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 (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.
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)