help troubleshooting deadlocks in sql server database
Posted
by
Makach
on Stack Overflow
See other posts from Stack Overflow
or by Makach
Published on 2011-01-24T22:18:03Z
Indexed on
2011/01/30
23:25 UTC
Read the original article
Hit count: 203
sql-server-2008
|deadlock
I've got two database servers, (1) production (2) test
on the production database I get frequent deadlocks and I'm trying to find out what is causing it.
I take a backup of the database in production and restore it in test and when I perform the exact same scenario that yields deadlocks on the production server I am unable to reproduce in test.
any ideas/tips/hints would be much appreciated.
© Stack Overflow or respective owner