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 |
|
JonBob
Starting Member
2 Posts |
 Posted - 2002-10-02 : 14:26:06
|
| There are some microsoft stored procedures that can be created and run to detect and troubleshoot deadlocks. Any info. on finding them would be greatly appreciated, no luck so far with any of microsoft's sites. Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-02 : 14:47:12
|
| sp_lock will get you started. You can also use it in conjunction with sp_who and sp_who2. If you look up sp_lock in Books Online you'll find more info on it.Also read up on SQL Profiler, it allows you to trace various activities, including locking. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-02 : 14:53:14
|
Here's a bit of light reading  These articles themselves contains lots of usefull linksQ251004 INF: How to Monitor SQL Server 7.0 Blocking[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q251004[/url]Q271509 INF: How to Monitor SQL Server 2000 Blocking[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q271509[/url]Q224453 INF: Resolving SQL Server 7.0 or 2000 Blocking Problems[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q224453[/url]INF: SQL Blocking Due to [[COMPILE]] Locks[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263889[/url]INF: Reducing Lock Contention in SQL Server[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q75722[/url]HTHJasper Smith |
|
|
|
|
|
|
Deadlocks