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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Server Busy

Author  Topic 

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2009-12-13 : 19:59:59
We are experiencing the Server being very busy and I have lookied into Activity Monitor as many databases and underlying users were connected and waiting for locks being released for them.

Can anyone suggest me as to where apart from the activity monitor can look using DMV's and Other activities I can encroach for assistance.

Thanks All.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-12-14 : 05:06:31
You must explore,first, who got the exclusive locks
http://connectsql.blogspot.com/2009/07/in-environment-where-more-then-one.html
and then move to reasons behind these locks, use proper isolation scheme
Go to Top of Page
   

- Advertisement -