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.
DOWNLOAD HERE
Reference : Pinal Dave (https://blog.sqlauthority.com)
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
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
Regards,
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?