sp_who3

  • Comments posted to this topic are about the item sp_who3

  • Good job, like the results. Thanks

  • It should be noted that this returns only those connections that are related to a request. There are a lot of connections that do not show up in this view.

  • i have recived following error

    Msg 102, Level 15, State 1, Procedure vwWho3, Line 8

    Incorrect syntax near '?'

  • I am also getting the error when executing

    select * from master.dbo,vwWho3

    Msg 208, Level 16, State 1, Line 1

    Invalid object name 'master.dbo.vwWho3'.

    Can someone help me with this?

  • This is awesome. I made one small change that others may find useful. Preceding the order by statement, I added the following where clause line to filter out the sp_who3 process. Change the name of the process, "dbo.sp_who3" in this case, to whatever yours shows up as. This varies depending on where you placed the stored procedure.

    where qt.objectid <> OBJECT_ID('dbo.sp_who3')

    ORDER BY

    er.blocking_session_id DESC,

    er.logical_reads + er.reads DESC,

    er.session_id

    END

  • Thanks for the script.

  • ...wow, it is as simple as that.

Viewing 8 posts - 1 through 7 (of 7 total)

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