Work around for SQL server performance issue

  • Gangadhara MS (11/21/2010)


    Dear Experts,

    We are having performance issues on production server.

    The following task i have carried out and i need your suggestion further.

    1.I have used profiler to trace the events and found some sp are having higher duration/IO/CPU usage i asked developer to fine tune.

    2.There was no maintance plan: i have created with Index rebuild and statistics update task to do the same.

    3.I have feeded the Profiler trace output to SQL server tuning adviser(DTA) but ended with "0" recommondations.

    Please guide me where and all i need to check further to improve performance.

    Thanks,

    Gangadhar'

    I have to ask, please... how long does procedure #1 take to run?

    --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)

  • Jeff Moden (11/23/2010)


    Gangadhara MS (11/21/2010)


    Dear Experts,

    We are having performance issues on production server.

    The following task i have carried out and i need your suggestion further.

    1.I have used profiler to trace the events and found some sp are having higher duration/IO/CPU usage i asked developer to fine tune.

    2.There was no maintance plan: i have created with Index rebuild and statistics update task to do the same.

    3.I have feeded the Profiler trace output to SQL server tuning adviser(DTA) but ended with "0" recommondations.

    Please guide me where and all i need to check further to improve performance.

    Thanks,

    Gangadhar'

    I have to ask, please... how long does procedure #1 take to run?

    I also asked 🙂

  • Refactoring this stuff is WAY beyond a forum - it simply cannot be effectively done. I agree with the other poster who said it is time to call in a professional tuner.

    I also do not believe that memory will help out here but a professional should be able to ensure you have that set up optimally as well. I have to say that if you are not sure you have memory set up on a beefy enterprise edition box you REALLY need a pro to give your entire system and app and database a review. There are likely countless things to be improved!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 3 posts - 31 through 32 (of 32 total)

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