Post reply

Software to monitor SQL Server..

  • May 19, 2005 at 5:34 am

    #109409

    Hi,

    we are having problems with our system where we keep getting locks/deadlocks.. does anybody know of any good tools to monitor and report on this.. need something that will tell us which queries are causing the most locks and which are taking the longest to run.. i have been looking around in QA with sp_lock and dbcc inputbuffer and sp_who2 and such like to try and track the problems down but it really doesn't capture the information that we are after in time..

    anythought on any tools to help us track the problems down?

    thanks

    chris

  • May 19, 2005 at 5:45 am

    #559809

    Check out this very useful procedure by Erland Sommarskog, it should tell you what you want to know.

    http://www.sommarskog.se/sqlutil/aba_lockinfo.html

     

  • May 20, 2005 at 1:16 am

    #560107

    hi,

    i have never used this software but just heard about it.

    see if it gives you the expected results.

     

    http://www.dirig.com/solutions/sams/sql_server.html

     

    -- Parag

  • May 20, 2005 at 11:23 pm

    #560378

    You can run a Profiler first(if system permits)

  • May 25, 2005 at 9:52 am

    #561011

    The best thing to is run profiler (ensure it writes the data to disk and that there is sufficent disk space)

    Under Event ensure the following are recorded

    Locks: Deadlock

    Locks: DeadlockChain

    Storedprocedues:RPC:Completed

    TSQL:SQL:BatchCompleted

    Under filters exclude SQL Profiler from Application Name

    Under duration enter a time in miliseconds. I normally use 1000 this excluds all sql that takes less than 1 second

    keep the profile running and this should show you were the deadlocks are occuring look for deadlock chain in the profile

    if you need more help post the trace file

     

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

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