邢台职业技术学院学报
邢檯職業技術學院學報
형태직업기술학원학보
JOURNAL OF XINGTAI VOCATIONAL AND TECHNICAL COLLEGE
2011年
5期
78-81
,共4页
Delphi%Sybase%SQL%Server%进程%死锁%中止进程
Delphi%Sybase%SQL%Server%進程%死鎖%中止進程
Delphi%Sybase%SQL%Server%진정%사쇄%중지진정
Delphi%Sybase SQL Server%processes%deadlock%stop the process
Sybase数据库死锁的发生对系统的性能和吞吐量都有重要影响,经检测发现,管理信息系统的死锁主要是因为两个或多个线程(登录)抢占同一表数据资源引起的。如何快速地解除死锁?文中在阐述基本观点之后,采用Delphi语言对Sybase12.5的master数据库的操作,实现死锁进程的快速定位及解除,减小死锁对应用系统的影响。
Sybase數據庫死鎖的髮生對繫統的性能和吞吐量都有重要影響,經檢測髮現,管理信息繫統的死鎖主要是因為兩箇或多箇線程(登錄)搶佔同一錶數據資源引起的。如何快速地解除死鎖?文中在闡述基本觀點之後,採用Delphi語言對Sybase12.5的master數據庫的操作,實現死鎖進程的快速定位及解除,減小死鎖對應用繫統的影響。
Sybase수거고사쇄적발생대계통적성능화탄토량도유중요영향,경검측발현,관리신식계통적사쇄주요시인위량개혹다개선정(등록)창점동일표수거자원인기적。여하쾌속지해제사쇄?문중재천술기본관점지후,채용Delphi어언대Sybase12.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.