Monitoring Blocks

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Leo Peysakhovich » Monitoring Blocks

Monitoring Blocks

Rate Topic

Display Mode

Topic Options

Author

Message

Leo Peysakhovich

Posted Thursday, February 03, 2005 2:16 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129, Visits: 205

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/monitoringblocks.asp

Post #159514

Andriy Lishchynskyy

Posted Thursday, February 10, 2005 1:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, July 26, 2005 6:59 AM
Points: 2, Visits: 1

aba_lockinfo stored procedure also does its job well

Post #160746

Leo Peysakhovich

Posted Thursday, February 10, 2005 8:42 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129, Visits: 205

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.

Post #160841

Bret Mitchell

Posted Monday, October 17, 2005 8:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 8:14 AM
Points: 8, Visits: 69

I have never heared of the KILL command causing a corrupt database; has anyone seen or heard of this happening?

Post #229376

Sam Greene

Posted Thursday, January 04, 2007 4:40 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 6:09 PM
Points: 253, Visits: 493

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?

Post #334530

« Prev Topic | Next Topic »

Permissions