sp_who3

Question

Post reply

sp_who3

gerhard-356547

SSC Rookie

Points: 41
More actions
July 30, 2011 at 12:50 pm

#390091

Comments posted to this topic are about the item sp_who3

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

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

Eric Willemstein SSChasing Mays Points: 610 More actions · Answer 1

Eric Willemstein

SSChasing Mays

Points: 610

August 1, 2011 at 9:48 am

#1361657

Good job, like the results. Thanks

whosenext SSC Rookie Points: 38 More actions · Answer 2

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.

prodyut.dasgupta SSC Enthusiast Points: 115 More actions · Answer 3

i have recived following error

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

Incorrect syntax near '?'

lup328 SSC-Addicted Points: 477 More actions · Answer 4

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?

kenneth.gore SSC-Addicted Points: 451 More actions · Answer 5

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