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 |
|
sippon77
Starting Member
13 Posts |
 Posted - 2007-05-09 : 14:56:52
|
| Hi,We have been having DB performance issues due to blocking. Is there any way to set up monitors that would alert blocking in DB or high resource utilization. Any native tools or third party tools will help although i prefer setting up a SQL job for this.Any help is appreciated. Thanks is advance.-sippon |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-09 : 15:39:19
|
| You can set job to query blocked column in master..stsprocesses. |
 |
|
|
|
|
|
DB performance | Blocking