| 从死锁角度研究数据库性能的优化 |
| |
| 引用本文： | 孟德超.从死锁角度研究数据库性能的优化[J].价值工程,2012,31(3):158. |
| |
| 作者姓名： | 孟德超 |
| |
| 作者单位： | 天津大学管理与经济学部,天津,300072 |
| |
| 摘 要： | 数据库的死锁问题在很大程度上影响着数据库的性能,死锁研究也是数据库性能优化的一个重要方面。本文以SQL Server数据库为例,从一个死锁实例入手,对死锁产生的原因进行深入剖析,然后分析死锁影响数据库性能的原因,最后文章给出了避免死锁的若干方法。
|
| 关 键 词： | 死锁 数据库性能 优化 |
Optimizing Database Performance from the Perspective of Deadlock |
| |
| Meng Dechao.Optimizing Database Performance from the Perspective of Deadlock[J].Value Engineering,2012,31(3):158. |
| |
| Authors: | Meng Dechao |
| |
| Institution: | Meng Dechao(School of Management,Tianjin University,Tianjin 300072,China) |
| |
| Abstract: | The deadlock problem of database largely affects its performance.Deadlock research is an important aspect of database performance optimization.This paper starts from an instance of a deadlock based on SQL Server,searching for the causes of the deadlock in depth.And then analyze how deadlock affects database performance.Finally,the article shows several methods to avoid deadlock. |
| |
| Keywords: | deadlock database performance optimization |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
