Post reply

Please suggest Tools for sql server 2005

  • December 30, 2007 at 7:28 pm

    #119502

    Question 1

    I want to check which is the best easy to use cost saving tool in sql server which can do a check the performance of a query and rewrite the query with best performance

    Question 2

    Which is the best tool for load testing tool in sql server, which is easy to understand and use.

    Question 3

    Which tool monitors the changes in the server including the dba's activities and send report to the audit team.

    Qustion 4

    Which tool can send notification about the job's failed , backup task failed etc.

    Question 5

    Which tool can suggest the correct index for all the tables

    Please recommend me a tool for all this which is easy to use + cost saving and their licencing details with their pricing.

  • December 30, 2007 at 10:24 pm

    #763586

    You crammin' for an interview or a test? Or, is this a take home test.

    Please, do your own homework.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 30, 2007 at 11:30 pm

    #763589

    Query Analyzer

  • December 30, 2007 at 11:33 pm

    #763590

    There's no tool in existance that can rewrite a query in the most optimal way, or list the 'correct' indexes for a table. That's why skilled DBAs are still needed.

    Profiler is good for finding poorly performing queries, so (in SP2) is the performance dashboard. The Database tuning adviser can suggest indexes for tables, but its suggestions are not always the best. Both are tools included with SQL Server, so no additional cost.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 31, 2007 at 7:10 am

    #763689

    Check RedGate and Idera. They have lot of what you are asking.

  • December 31, 2007 at 1:03 pm

    #763778

    You will get more for your money by hiring a qualified DBA rather than buying a tool and falsely believing it will solve any/all of your problems. If the answers to all of your questions could be solved by installing a s/w product and going home, we (DBA's) would not be necessary.

  • January 1, 2008 at 10:42 am

    #763853

    I agree - get a DBA. As you're asking these questions even if we suggested tools/methods ( most are available one way or another for what you ask ) you'd still need a DBA to interpret the information

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 1, 2008 at 11:46 am

    #763858

    One more vote for hiring someone. You'll need them even with a tool.

    Tools do help, but you should match the tool to the DBA if you can.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply