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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy