Post reply

sql server running slow

  • February 27, 2008 at 9:14 pm

    #378956

    could you please explain me the order of steps to take when a sql server is running slow?

    Regards,

    Garry

  • February 27, 2008 at 9:33 pm

    #782976

    Does it happen constantly or sporadically?

    If constantly, check your hardware.

    If sporadically, check locks, scripts, stored procedures, ... all of software.

  • February 27, 2008 at 10:19 pm

    #782982

    I came to know that SQL server is running slow because of its full utilization of memory

    In this case wat are the steps to take? could you explain me in detail? plz....

    thanks

    gary

  • February 27, 2008 at 11:20 pm

    #782994

    That's a very big question. It depends very much on the circumstances - a user, specific time of day, all the time, random times, etc

    I'd start with performance monitor, checking the current stats against the baseline (you do have a baseline?)

    Also profiler, looking for long running queries, and the exec_sessions and exec_requests DMVs, looking for blocking or excessive waits.

    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

  • February 28, 2008 at 8:31 am

    #783221

    You can use many methodologies

    1. run sp_who to find longer running processes and blocking

    2. sp_lock to find locks in the server

    3. use SQL profiler to trace sql performance problems

    4. use perfmon to analyze os performance

    and many more you need to look at the root first and then can tune in depth then.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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