Best Practices Analyzer When will SQL Server 2005 Best Practices Analyzer be available?
It will ship in Q1 2007 along with SQL Server 2005 Service Pack 2 RTM. You will find a link to it from the SQL Server 2005 SP2 Feature Pack. What are some of the new features in SQL Server 2005 Best Practices Analyzer? High impact rules The SQL Server product team has worked closely with the SQL Server customer support team to understand what issues customers are commonly experiencing. Store Scans Results as XML In 1.0, you would store your scan results in a SQL Server repository. This was good if your SQL Server was functioning. But if you were having problems or want to quickly send scan results to a fellow DBA, this was somewhat annoying. Store Scan Settings as XML You can setup scans of servers and store them in XML. This can later be used from the GUI or the command line tool. Interactive Reporting After completing your scan, you can see a concise list of potential issues in your environment. Each rule will be accompanied by an article describing how it was detected, why it is imp
