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 |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2008-11-14 : 14:53:24
|
| Hi,I have a customer with a CRM application running on SQL 2000 that is experiencing locking issue.There are 100 users using the system at peak times. There are a number of triggers, stored procedures and integration interfaces to the database that work with the database.Can I get trace details of locking ? how?Any suggestions to fix such locking issue?thanks, |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-14 : 15:18:59
|
| You can get better information by using SQL Server Profiler, also SP_LOCK will be really helpfull |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-14 : 15:23:47
|
| Here is good one from Mladen.http://weblogs.sqlteam.com/mladenp/archive/2008/04/29/SQL-Server-2005-Get-full-information-about-transaction-locks.aspx |
|
|
|
|
|
|
SQL LOCK