Saturday, March 31, 2007

SQL Server 2005 Best Practice Analyzer

SQL Server 2005 Best Practice Analyzer: "I've been testing the re-released Best Practice Analyzer for SQL2005 called SQL Server Best Practice Analyzer 2.0, available for download here:

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

I find this tool to be very handy for identifying database Security & Performance issues and making fix recommendations, even though it is CTP and not final release yet.

It does NOT have to be installed on a remote server, just on a DBA's Mgmt Studio workstation. It DOES, however, require that you have Admin priviledges on the remote SQL Server in order to access the Windows registry."

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home