Compartilhar via


Best Practices Analyzer for SQL Server 2005

I’ve seen a few posts in forums and newsgroups requesting Best Practices Analyzer support for SQL Server 2005.  Good news… we just started developing a new version that will work with SQL Server 2005!  If you aren’t familiar with this type of utility, check out Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0 or Microsoft Exchange Server Best Practices Analyzer Tool v2.5.

It is very early in the development cycle and we’d like to hear your thoughts on the following questions:

1) Is a Best Practices Analyzer tool something that you feel is important for SQL Server 2005?
2) What versions of SQL Server should this support? (SQL Server 2005 only, SQL Server 2000+)
3) What components should this support? (SQL Server Engine, Analysis Services, Reporting Services, Notification Services, Integration Services)
4) What features would you like to see in it?

I'll post the results of our plans once things become clearer.

Thanks,
-Paul

Comments

  • Anonymous
    April 07, 2006
    The comment has been removed

  • Anonymous
    April 07, 2006
    The comment has been removed

  • Anonymous
    April 07, 2006
    I would still like a T-SQL best practise check on the use of formal parameters.

    exec sp_help @objname = 'tablename' -- This would check as OK

    exec sp_help 'tablename' -- This would check as BAD missing  formal parameter name

    Tim S

  • Anonymous
    April 09, 2006
    it would be nice if the BPA warns about implicit type conversions within procedures and statements.

  • Anonymous
    April 10, 2006
    The comment has been removed

  • Anonymous
    April 18, 2006
    The comment has been removed

  • Anonymous
    April 20, 2006
    When you create a temp table it should warn you if you don't specifiy NULL or NOT NULL for the columns.

    Tim S

  • Anonymous
    April 29, 2006
    Thank you to everybody who posted comments in newsgroups, forums, and on the first SQL Server™ Best Practices...

  • Anonymous
    May 10, 2006
    Have just found this great tool, would like to see some rule customization and adding new rules to make it fit our standards more closely.

  • Anonymous
    May 12, 2006
    The comment has been removed

  • Anonymous
    June 19, 2006
    I've been a regular user of the sql bpa on 2000 for some time. I have well over 100 databases and the tool is great for getting an overview of security & compatiibility issues. I think it's great and would be interested in seeing a beta for 2005 when available. Like folks above I would love some suggested fixes, but even a report that could be sent to developers with in depth info on the various issues would be much appreciated. Especially if that report is sorted by database. sqlbpa scans rules, then for each rule give a breakdown of exceptions I would love to see an option to sort by server then database then rule-results. If you are to take action on an item it's likely that you will do this on an aplication by application basis.

  • Anonymous
    August 04, 2006
    I have just started using the DBA as part of our change management process, and I find it very useful.  So, yes, I think we need an analyzer tool for SQL 2005.  Additional features that I would like to see in the 2005 version include the abilitiy to specify individual database objects to analyze and, like Mr. Rosenthal, a configurable report to send to the developers.  For example, when Developer X sends me a script for deployment that contains one create stored procedure and two alter databases, I would like to run the analyzer on just the three affected objects and generate a report that can be sent back to Developer X with the good and/or bad news.

  • Anonymous
    August 22, 2006
    I love to see the new version support both SQL 2000 and 2005. One of the things that I'd appreciate is a script/utility that can be run on a remote server so that the resulting data can be imported into a local repository for processing and reporting. It's not always feasible to run any kind of  installation on a remote domain. We are often asked to do once-off checks for clients and this function would be invaluable.

  • Anonymous
    September 01, 2006
    Is the SQL Server 2005 Best Practices Analyzer available yet?
    I noticed the following webcast:
    TechNet Webcast: Using the SQL Server Upgrade Advisor and New SQL Server 2005 Best Practices Analyzer Tools (Level 200)  (http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032306503&EventCategory=4&culture=en-US&CountryCode=US)

  • Anonymous
    September 27, 2006
    "SQL Server Best Practices Analyzer " and "SQL Server Health and History Tool (SQLH2)" are my favorite SQL Server tools. They helped me a lot with my DBA tasks.
    Now I work in a company where we have SQL server clusters. SQLH2 doesn't work properly in clustered environment. I have not had chance to test sqlbpa on cluster, but I think it's important to have these great tools in clustered enviroment. May be there could be some "best practices" for SQL Servers on clusters.

  • Anonymous
    September 28, 2006
    The comment has been removed

  • Anonymous
    October 02, 2006
    I'd love to see the equivalent in Analysis Services.  Is this on anyone's radar?

  • Anonymous
    October 12, 2006
    Swanie said: "I'd love to see the equivalent in Analysis Services.  Is this on anyone's radar?" Yes, we are working with the BI team to provide some rules for SSAS and SSIS.  This was covered in the webcast which you can view on demand at microsoft.com/webcasts/. Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability

  • Anonymous
    October 19, 2006
    The comment has been removed

  • Anonymous
    November 22, 2006
    The comment has been removed

  • Anonymous
    December 07, 2006
    Do you plan to have a beta or CTP version of BPA for SS2k5?.  Joel Cabot

  • Anonymous
    December 11, 2006
    I used the SQL Server 2000 BPA a lot, and got a lot of value from it. Any update on when the 2005 version will be available?

  • Anonymous
    December 19, 2006
    The comment has been removed

  • Anonymous
    January 09, 2007
    Hi there, SQL 2005 has been here for a while now, is there any movement on the release of the Best Practices Analyser that you mentioned was "in production" ? Thanks

  • Anonymous
    January 10, 2007
    PingBack from http://chaespot.com/mssql/2007/01/11/msde-and-sql-server-manager-easy-management-of-msdems-sql-databases/

  • Anonymous
    January 12, 2007
    Any word at all on this tool becoming available. A beta? A CTP? We've got months old announcements. Those of us who found the tool useful as a mechanism for cleaning up databases under development would sure like to see a new version for 2005. Anyone from MS listening to this one any more?

  • Anonymous
    January 29, 2007
    I think it should be support both SQL Server 2000 and 2005. As I want to enjoy the following features from the new version of Best Practices Analyzer:

  1. It should support "Customed Rule" defined by DBA. Just like FxCop. e.g. The current rule of user object naming could cover more areas: constraints naming standard, all objects must have a customed name instead of using a irregular name generated by SQL Server. If the rules can be defined by DBA, then the Best Practices Analyzer would become more flexible.
  2. It would be better if it supports .sql or .txt file types. As our office use weekly release, the DB scripts (.sql files) are centralized in a repository for each release. We would like to automate the best Practices Analyzer for reading the .sql files before each release. Reading .sql files could help us a lot on the automated process. Best Practices Analyzer is a great tool for database quality improvement process. I look forward to enjoying the new release features in the near future.
  • Anonymous
    January 29, 2007
    As I may interesetd in looking at the SQL query provided in a SQL Trace file only, if the Compliance Report supports filtering criteria, e.g. by database/file, it would be great!!

  • Anonymous
    April 02, 2007
    Does anyone know if the SQL 2005 Best Practices Analyzer has been lanuched yet?

  • Anonymous
    April 11, 2007
    Here it is guys!! (Ladies too!).... http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

  • Anonymous
    June 07, 2007
    I think the SQL BPA is a great tool! But the latest release I've come across so far, is the February 2007 CTP. When will a release that can be deployed in production be released?

  • Anonymous
    May 18, 2008
    disney Ben barnes <a href= http://ben-barnes.barerube.cn >Ben bell barnes</a> [url=http://ben-barnes.barerube.cn]Ben bell barnes[/url]

  • Anonymous
    May 19, 2008
    I can't seem to get the BPA to work with a clustered sql 2005 resource - is this supported?

  • Anonymous
    June 07, 2008
    I’ve seen a few posts in forums and newsgroups requesting Best Practices Analyzer support for SQL Server 2005. Good news… we just started developing a new version that will work with SQL Server 2005! If you aren’t familiar with this type of utility, chec

  • Anonymous
    July 23, 2008
    i just need to enquire if SQL 2K5 BPA is Cluster Aware , i installed on a Cluster but it didnt Worked , Please assist

  • Anonymous
    August 10, 2009
    I have a problem.  Server 2003 R2, SQL 2005 SP3, Installed.  When I get to the screen "Configure Database Engine" I can't select a DB, I see the 4 defaults and the one I have for SCCM however, there are NO CHECKBOXES like on this person screen shot example:  http://www.mssqltips.com/tip.asp?tip=1302 I'm stuck because I can't select the DB, clicking "Select All" doesn't work because I have no check boxes.  Any help would be appreciated.