浅析SQL SERVER中死锁  

On Deadlock in SQL SERVER

作　　者：丁莉[1] 张静[1] 游凯何[1] 

机构地区：[1]邢台职业技术学院

出　　处：《科技创新导报》2010年第23期35-35,共1页Science and Technology Innovation Herald

摘　　要：死锁问题虽然不能完全避免,但可以使死锁的数量减至最少。越早的考虑数据库设计中的并发性问题,就越可以提高代码执行的效率,降低程序开发和维护的成本。本文从死锁产生的原因谈起,提出了一些在SQL SERVER中避免和解决死锁的方法。The deadbolt lock question although cannot completely avoid,but may cause the deadbolt lock the quantity to reduce to few. In the earlier consideration database design concurrency question, more may enhance the code execution the efficiency,reduces the procedured evelopment and the maintenance cost. This article the reason which produces from the deadbolt lock mentions,proposed some avoid in SQLSERVER with the solution deadbolt lock method.

关 键 词：死锁 资源竞争 提交 回滚 隔离级别 事务 

分 类 号：TP31[自动化与计算机技术—计算机软件与理论]