Post reply

Connections executing the saame Stored Procedure

  • March 5, 2009 at 3:17 am

    #95268

    Hi,

    In our production database, one single SP is getting executed executed across several connections and after some time temp db contention is occurring. Can anyone please tell me what is the query I should use to find out the number of connections that are executing this SP?

  • March 5, 2009 at 3:31 am

    #953878

    " sp_who2 active " will give you details of the active transactions on a given instance

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • March 5, 2009 at 5:21 am

    #953925

    Can i filter the results on a SP name?

  • March 9, 2009 at 5:26 am

    #955876

    By using DBCC opentran command you can find the transaction which is running longer time.

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

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