Concurrency Control and Self-optimization based on SQL Server Database System

DOI

10.2991/meita-16.2017.14How to use a DOI?

Keywords

Transaction; SQL Server; concurrent; lock mechanism

Abstract

With the great development of computer science technology and electronic information, all enterprises have established their own information systems. The database as the core and foundation of information system, it has also been more and more widely used. So the performance of the database has been widespread concern in the industry. Traditional performance testing work by hand, it is impossible to simulate high-volume users concurrent access to the real situation of the system, the effect is not very satisfactory. With the continuous improvement of technical means there have been many related software testing tools to simulate a large number of concurrent users of the scene, so the system performance inspection. The concurrency control mechanism of SQL Server is analyzed, and the principle of concurrency service design is summarized on the basis of practice. The typical concurrency problem, custom lock application and so on are discussed. Finally, an application example of concurrency control is given.

Copyright

© 2017, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Rongchuan Guo
PY  - 2017/02
DA  - 2017/02
TI  - Concurrency Control and Self-optimization based on SQL Server Database System
BT  - Proceedings of the 2016 2nd International Conference on Materials Engineering and Information Technology Applications (MEITA 2016)
PB  - Atlantis Press
SP  - 59
EP  - 63
SN  - 2352-5401
UR  - https://doi.org/10.2991/meita-16.2017.14
DO  - 10.2991/meita-16.2017.14
ID  - Guo2017/02
ER  -