Post reply

SQL SERVER PERFORMANCE

  • December 18, 2008 at 1:01 am

    #197327

    If sql server performance is slow first How can we find it? plz tell me the procedure. How can we go?

    Will you tell me the Navigation.

  • December 18, 2008 at 5:27 am

    #914422

    What do you mean by "performance is slow"

    Is this normal, or is the server unusually slow?

    Have you made any changes recently?

    Are there more users than normal?

    Is there excessive blocking?

    Are you seeing high wait times? If so, what type?

    If performance is always slow, run profiler for an hour or so, capture all of the queries running, find the worst ones and see if you can optimise them

    If the server is unusually slow, you need to find out what's different to normal.

    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 18, 2008 at 6:40 am

    #914475

    That's a huge topic. I posted an article [/url]on it that just barely scratches the surface. It can at least get you started so that you can begin to ask questions.

    "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

  • December 18, 2008 at 11:36 am

    #914791

    profiler

  • December 18, 2008 at 11:59 am

    #914803

    Snorkel.

    But seriously, Profiler might not give the answer. What if there's a problem with memory or tempdb or disk space and there are waits occurring because page latches or something else.

    You can't simply say the server is slow. You have to say, slow as compared to... that other server, the way it was yesterday, the way I want it to be... There has to be a basis to work from as well as mechanisms to approach the basis. That's the point that Gail made.

    "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

  • December 30, 2008 at 4:43 am

    #918921

    hi,

    as per all other tell you there is various reason behind that .....first compare your performance with previous days performance and find when performance goes down on any specific event or like that you have to research that please give brief description

    Raj Acharya

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

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