Best Practice Analyzer – Can sneak in and give some important tips!


Lets start the month with some best practice’s.

Microsoft® SQL Server® 2008 R2 Best Practices Analyzer will allow you to scan your sql server instance and will report potential issues.There is a error area and warning area which will give detailed explanation of the issue.

Looking at this report will help you to fix potential problems.

Best practice analyzer works with Microsoft Baseline Config Analyzer and baseline config analyzer is used to scan the instance.

Recently when I scanned instance,I got the below report which quickly helped me to fix some potential issues.

Just give a look at the error part.You should never see this in PRODUCTION environment!

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s