SQL Server Performance

SQL Server Best Practices Wizard Beta

Discussion in 'Forum Announcements' started by bradmcgehee, Nov 17, 2003.

  1. bradmcgehee New Member

  2. Negative New Member

    That tool is quite nifty. I hope in future version they allow creation of custom rules, then it would be really sweet. I ran it against a few of our servers and found some things that we missed. I will likely run this against all of our servers.
  3. bradmcgehee New Member

    From what I heard at PASS, the final version will allow for custom rules.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  4. Luis Martin Moderator

    Only work with SQL 2k write?



    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  5. satya Moderator

    Ofcourse.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  6. Luis Martin Moderator

    I was testing in my laptop, is a very good tool.
    But, except one, all my customers has SQL 7 (3rd word guys....)


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  7. satya Moderator

    aah haa.. don't say that, still many shops out there are on 6.5.... sometimes its hard to upgrade on enterprise network.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  8. thomas New Member

    That is a very nifty tool, epseically the Yukon Readiness bit.

    Some of the rules seem a bit over-the-top, but you can always leave them out.

    Thanks for poitning it out, Brad!

    Tom Pullen
    DBA, Oxfam GB
  9. Luis Martin Moderator

    Very nifty tool.
    The question is, how to tell developers: guys Microsoft said you have about 400 (real case, no imanginary) recomendations to improve your software.

    Thanks Brad.

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  10. satya Moderator

    I think the original version caused a problem to a few people - it's been updated, so if you did download it, download it again.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  11. Luis Martin Moderator

    I will, but when I see recomendations like " there is a begin transaction without commit", in a lot of SP, I don't think is because Beta.



    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  12. satya Moderator

    This problem is more likely to occur when writing nested stored procedures.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page