Post reply

Performance tuning

  • May 27, 2009 at 7:25 am

    #131947

    Hi ,

    I request you to let me know the steps to be implemented in performance tuning .What are the ways that can be done to improve eg:Index,2.Partitioning

    etc., Please how performance tuning can be done with Index as well as using partitioning .

    How execution plan and explain can be obtained for particular object can u explain with one example?

    Thanks,

    Narenndra

  • May 27, 2009 at 7:31 am

    #1000571

    narendra.pola (5/27/2009)

    What are the ways that can be done to improve

    Generally, change the queries to remove unnecessary operations and to allow them to use indexes effectivly and then tune the indexes to support the queries.

    How execution plan and explain can be obtained for particular object can u explain with one example?

    Sorry, not sure what you're asking.

    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

  • May 27, 2009 at 7:42 am

    #1000585

    Thanks for the response in quick time wat i am expecting regarding the secnond part of my question is can some one explain the execution plan and explain plan and how can they be implemented

  • May 27, 2009 at 7:44 am

    #1000591

    Gail has a couple of articles on performance tuning[/url] over at Simple Talk. You might want to check them out. I have an introductory article[/url] on execution plans that might help you over there as well.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 27, 2009 at 7:50 am

    #1000599

    I Guess this video tutorial on Getting the most performance from SQL Server application will guide you adding to above suggestions...

    http://wtv.watchtechvideos.com/topic224.html

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • May 27, 2009 at 7:52 am

    #1000601

    There's a book that Grant Fritchey wrote, not sure if it's still available electronically. Also you could take a look at my blog.

    http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/

    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

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

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