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

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.