Post reply

T-SQL performance tools?

  • September 22, 2006 at 8:46 am

    #170437

    A friend of mine has been working with SQL 2005 quite a bit and says that there is a tool in the new Query Analyzer that allows you to analyze how a query is being executed in more detail.  Anyone know more about this feature?

  • September 22, 2006 at 8:58 am

    #662001

    Is he talking about this?

    Menu >> Query >> Include execution plan?

     

    There's a lot more details than before (or at least more user friendly) but I wouldn't call that a new tool!!

  • September 22, 2006 at 9:05 am

    #662006

    Where can I find more info on this tool?

  • September 22, 2006 at 9:23 am

    #662009

    A good place to start would be to read this topic and all subtopics in the books online :

    execution plans [SQL Server]

     

    Also once you start unsing it just reffer back to the books online as you need more information.  Sorry to be so vague but there have been 100s of articles on query optimisation.  So I guess you just need to start using it and see where it goes for you .

  • September 22, 2006 at 9:31 am

    #662010

    Thanks!

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

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