January 29, 2009 at 10:57 am
Hi,
Is there a way to alarm/moniter of any deadlock.
As many times it happened that many of my application job (due to DML and data fetched from many linked server)and my db bkp jobs hanged was only notified when my jobs kicked of in the next schedule by application team.
Is there a Query to check, which i can run from Query anlayser.
Can any one of you suggest ideas.
January 29, 2009 at 11:13 am
I don't know of a direct way to do that through T-SQL. There are monitoring tools that can alert you when there's a deadlock. I think RedGate's SQL Response can do that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 29, 2009 at 12:45 pm
A deadlock won't cause a job to hang. It would cause a job to fail. Are you sure you're getting deadlocks, and not regular blocking?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply