Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2007-07-11 : 15:42:10
|
| Guys,We had some issues here - a certain process was blocking other processes, things were hanging and caused problems. I am now thinking to set up some type of monitoring to prevent this in the future.The goal is to be able to tell which processID is blocking which processID for > 't' amount of time and send an alert if such a situation occurs.Can someone suggest a way of doing it?I am currently exploring how I can utilize master..sysprocesses for this purpose, but cannot figure out best way of achieving this goal.Any suggestions?Thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-11 : 15:57:53
|
| Use sp_who2 to get this information.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
How to alert on constant blocking?