SQL Server 2000 Best Practices Analyzer

[ecobb]

Has anyone tried the SQL Server 2000 Best Practices Analyzer yet? I downloaded it today from Microsoft (

http://www.microsoft.com/downloads/...F-D3CA-44EE-893E-9E07339C1F22&displaylang=en)

and I have to admit, it's a pretty slick little tool!

According to the Microsoft overview: Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices. These Best Practices typically relate to the usage and administration aspects of SQL Server databases and ensure that your SQL Servers are managed and operated well.

It will scan your databases and check database design, configuration options, T-SQL (stored procedures and triggers), Backup and Recovery, 2003 and Yukon readiness, and a whole lot more!

I just ran it on my dev. server and was pretty impressed at the details in the reports. I was just wondering if anyone else had tried it and what their opinion of it was.



Hope This Helps!

Ecobb

"Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer." - Homer Simpson

 

[Nowell]

Hi,

Yeah I started using it last week, very useful.
Some of the tests are not really that important and I have found that the 'cursor for update' even brings up errors on system stored procedures. But I decided to email the manager of the SQL server engine at Microsoft and he actually replied, he said don't worry too much about the cursor for update test. He also said they would fix the prob in the next release......to be honest I was just happy that he actually answered ! !

For finding out which of your databases are not being backed up etc its very good.

One of the tests tell you not to add stored procedures to system databases, I have all my log shipping / backup stored procs stored in the master database, what are your opinions on this?

Regards

Nowell