sql server 2000 在高并发测试下的一些问题及解决（Some problems and solutions of SQL Server 2000 under high concurrency test）.docVIP

sql server 2000 在高并发测试下的一些问题及解决（Some problems and solutions of SQL Server 2000 under high concurrency test） Some problems and solutions of SQL Server 2000 under high concurrency test Author: Ronghao source: BlogJava cool Qin network collection 2008-06-29 abstract Cool Qin network test results: whether it is hibernate or JDBC, concurrent case will soon cause SQL Server 2000 deadlock, change two database driven JTDS and jturbo, deadlock situation has not changed. Conclusion: the lock configuration strategy of the SQL Server 2000 database does not support, or the database itself does not support simultaneous operations (or incomplete support) for different rows The tests are performed on SQL Server 2000, and the methods for workflow operations are multithreaded concurrent in unit tests. The test found that sqlserver appeared deadlock quite a bit, some typical cases: 1, the same table first insert, and then update will soon cause deadlock, regardless of whether the operation is the same record Solution: for the same record, you need to adjust the mapping strategy of the hibernate so that a insert completes the operation. For different records, you need to manually flush in the code so that update is prior to insert. 2, the two table for more than update operation, two tables alternate update will soon cause deadlock Solution: manually flush in the code to ensure that the update of the two tables does not alternate. 3, a large range of scanning select and update mixed will also lead to deadlock Solution: optimize SQL, minimize the SQL statement, and reduce the association query by increasing the persistence field for po In most cases, database deadlocks are avoided and, oddly, events that lock up are not detected by the profiler during deadlocks. However, in some special cases (for example, a direct combination of multiple concurrent aggregation), deadlock still occurs. Finally, the method must be synchronized with the synchronized keyword, which is done through the sync