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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-09 : 10:16:50
|
| Owas writes "I am facing deadlocks when running the Stored Procedures. What can be the reasons of Dead Locks" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-09 : 10:17:36
|
| Have you looked up "deadlocks" in Books Online? There are several entries that not only describe deadlocking, but also how to avoid it. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-09 : 11:25:05
|
| Always poor design.You cannot totally eliminate deadlocks but can easily design to minimise them.Common cause - trying to run reports from an on-line updatable database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-09 : 13:04:34
|
Here's a bit of light reading  Q251004 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 |
|
|
|
|
|
|
Transaction Deadlock