Sybase死锁进程的快速定位及解除

Quickly Locate and Release of Sybase Deadlock Process

Sybase数据库死锁的发生对系统的性能和吞吐量都有重要影响,经检测发现,管理信息系统的死锁主要是因为两个或多个线程(登录)抢占同一表数据资源引起的。如何快速地解除死锁?文中在阐述基本观点之后,采用Delphi语言对Sybase 12.5的master数据库的操作,实现死锁进程的快速定位及解除,减小死锁对应用系统的影响。

Sybase database, the occurrence of deadlock and throughput performance of the system have a significant impact, the test showed that the deadlock management information system is mainly because two or more threads （Login） occupy the same table due to data resources. How to quickly lift the deadlock？ This paper describes the basic ideas in the following language on Sybase 12.5 by Delphi＇s master database operation, to achieve deadlock quickly locate and release process, reduce the impact of the application system deadlock.