SQL Server数据库封锁及死锁研究

Research on Lock and Dead Lock of SQL Server Database

首先简要介绍了SQLServer数据库的封锁与死锁,然后论述了预防SQLServer数据库死锁的若干策略和方法,最后分析并讨论了几个典型的易导致死锁的SQL程序及其解决办法。

This paper introduces the lock and dead lock of SQL Server database, discusses the principles and methods to prevent dead lock of SQL Server database, analyses and presents several solutions to some incorrect SQL programs which easily result in dead lock.