February 3, 2005 at 2:16 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/monitoringblocks.asp
February 10, 2005 at 1:09 am
aba_lockinfo stored procedure also does its job well
February 10, 2005 at 8:42 am
There are many ways and many people develop similar processes. I did outlined some of aspects. That's it. sp_who proc is working fine. Who need sp_who2? But it is exists as well.
October 17, 2005 at 8:52 am
I have never heared of the KILL command causing a corrupt database; has anyone seen or heard of this happening?
January 4, 2007 at 4:40 pm
Is P_MON_CONNECTIONS intended to be run when investigating blocks identified by the previous procs? first I was thinking it was the main proc which fired off the sp_who logging proc, since runs a job passed as a parameter, but then i see the hostname parameter which makes me think that first you identify a host which is blocking and then run this proc on that hostname. Is this correct?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply