Post reply

wanted: tool analysing db requests and which comes up with index suggestions

  • January 12, 2006 at 8:24 am

    #364645

    Hi,

    Our database is growing (and growing, and growing)...

    So performance is becoming a hot item.

    Is there a tool out there which monitors the requests on the database and comes up with the most ideal indexes..?

    Cheers,

     

    Jan

  • January 12, 2006 at 9:32 am

    #614409

    Yes it's called a DBA, but please don't call them a tool

    To answer your question a little more seriously, you can always use sql profiler to capture the SQL being executed and save it to a file, then you can use the index tuning wizard to analyse the results.

    Personally i'm not a big fan of the ITW but it might give you somewhere to start from till you get to grips with analysing query plans.

    Mike

  • January 13, 2006 at 1:05 am

    #614539

    Mike,

    Thanks for your reply.

    I am a developer and they made me the tool called DBA.

    I hoped there are some tools out there who can make my role as DBA tool as easy as possible...

    Jan

  • January 13, 2006 at 2:07 am

    #614549

    No Problem Jan,

    You could also take a look at software from companies like Quest, i beleive they have this sort of thing available (at a cost), i've not used them before as I prefer a tried and trusted method (me) but if you're stuck then its worth a try getting the free trial.

    Mike

  • January 17, 2006 at 12:58 pm

    #615261

    Idera's Diagnostic Manager is another one ... Not terribly expensive. One of their performance features is called "worst performing", and will give you a list of all the SQL SPs, and individual SQL statements in the last 30 days. You can then look at some of those to see if they are poorly written.

Viewing 5 posts - 1 through 4 (of 4 total)

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