Systems Engineering and RDBMS

SQL Server 2005 Best Practices Analyzer

Posted by decipherinfosys on July 9, 2007

In case you have not downloaded the BPA already, I would recommend that you do so. You can get it from this URL:

http://www.microsoft.com/downloads/details.aspx?FamilyID=da0531e4-e94c-4991-82fa-f0e3fbd05e63&DisplayLang=en

BPA captures the data used for Windows and SQL Server configuration and has a list of pre-definedbest practices and recommendations to help you identify any potential issues in your environment. It is a very simple install and takes only a few seconds to install and when you launch it, the default screen looks like this:

img_1.jpg

You can scan three types of SQL Server Services –> the SQL Server Service, SSIS and SSAS. One can also choose to schedule the scans.

img_3.jpg

And when you run the report after doing the configuration, the report can organized in several different ways as well as exported out. Here is a sample run against one of the sample instances :

img_2.jpg

You can play around with the scans of different services to see the results in your pre-production and benchmark environments and then take those recommendations and evaluate them and apply them in your production environment. This along with the other health check tools from Microsoft for SQL Server should be run on a regular basis to ensure that the best practices are being followed.

Sorry, the comment form is closed at this time.

 
%d bloggers like this: