SQL SERVER – 2005 Best Practices Analyzer (July BPA)

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.


Reference : Pinal Dave (https://blog.sqlauthority.com)

Best Practices, SQL Download, SQL Utility
Previous Post
SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause
Next Post
SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example

Related Posts

2 Comments. Leave new

  • Hi Jacob,

    Great Question! I really enjoy answering question, which reader are interested.

    I am running this on our production server and I find it is mostly for Database Administrator. However Database Developer will be also find it useful.

    I am not sure about FXCOP as I have not used it before. As I said it is more focused on Administrator stuff than Developer. I have yet to find where it analyzes Index (may be not).

    Well, it suggest that when was last backup taken, password policy, database health, restoration status etc. I find it useful as we have lots of database and we can easily monitor with one click.

    We have Jr. DBA run all this report and export to one master table on one of the server. Where we query everyday and bring back reports of all the database we are running on production. It does provide good information once it is running on many server and report is generated for review.

    Anybody interested in looking at demo of how to start with BPA please visit : SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example

    Pinal Dave (SQLAuthority.com)

  • Hi pinal,
    I am wondering what kind of tests this tool peforms. Who will benefit from it? Is it the DBA? or a developer?

    Is it similar to FXCOP or Code analyzer which will test the TSQL code or Index, or other DB definition and will report the health of the system?

    I did a scan and what i could see is a dozen errors which says that I need to set autogrowth to be a lower value. I could not find any useful information after the scan.

    Am I missing something?


Leave a Reply