Blocking Questin

Question

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

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

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 1

When you run sp_who2, one column indicates the wait time.

Jim

iamsam.sandeep SSC-Addicted Points: 414 More actions · Answer 2

I have been using sp_who2 for a long time Did not notice this option. Thanks for the Answer.

Sandeep.

beejug1983 SSCertifiable Points: 6491 More actions · Answer 3

You can get the informations about blocking time by using

sys.sysprocesses

e.g. select waittime from sys.sysprocesses

Yuri55 SSCrazy Eights Points: 8449 More actions · Answer 4

You can use DMV sys.dm_exec_requests, standard reports have a lot of useful info,

but I do not think sp_who2 can help you with blocking wait time