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!


Leave a Reply

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

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

Facebook photo

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

Connecting to %s