Yesterday I posted small note about SQL SERVER - 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have created very simple and initial tutorial.
I encourage to follow that and once used it create your own reports in your desired format. Do not hesitate to install this add-on as I have use this previously to tune our production servers. 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. Following tutorial about BPA is ran on one of my old laptop, which has SQL Server 2005 installed. The SQL Server had many issues and they all are displayed in the result. Please note this is not production server and all the errors are intentionally generated. This tutorial is explained using images, which are very easy to understand.
If you have any question please visit original article at for follow up questions and suggestions : Original Article.
Tutorial : DOWNLOAD BPA and install it on your server.
I hope this initial tutorial will help DBA and Developer to start using SQL Server 2005 Best Practices Analyzer. Please play with different options and generate your own desired reports in your desired format.
Reference : Pinal Dave (http://www.SQLAuthority.com), SQLAuthority.com owns all the images copyrights.
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2200 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of two SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.