Click here to Skip to main content
Click here to Skip to main content

SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example

, 10 Jul 2007
Rate this:
Please Sign up or sign in to vote.
SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example

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.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

pinaldave
Founder http://blog.SQLAuthority.com
India India
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.
Follow on   Twitter

Comments and Discussions

 
GeneralMy vote of 5 Pinmembersravani.v21-May-12 18:38 
GeneralUseful for all DBAs Pinmemberk_michas11-Jul-07 3:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 11 Jul 2007
Article Copyright 2007 by pinaldave
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid