LOCKs out of solution in a lot of data, what the best locks The use of Pb in the implementation of the database tables everywhere operation, the system being given SQL Server has run out of LOCKS. Re-run your command when there are fewer active users. or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS. No changes made to databases. Wrong reasons 1, the approximately 220,000 Data Sheet Data Bank, the use of row-level locking Solutions 1, the revised data for the page locking locking watch 2, amending the "number of locks," the biggest Question : how to deal with data sheets have identified, can make better use of system resources? Such as data tables, a large number of users use the table-level locks to adopt all! System will increase the burden, how safe solution LOCKs out of solution in a lot of data, what the best locks The key is how you use 220,000 of the data? If the designation is a record of each visit, there should not be any problem with using the locks, but also provide concurrency. You should think that the solution is feasible, if the increased number of locks on the list, is not much like the lock on the system, will boost memory LOCKs out of solution in a lot of data, what the best locks Not number more than 100,000 ordinary lock LOCKs out of solution in a lot of data, what the best locks Configuration lock promote the threshold, visit the automatic use of page table lock. Create clustered index, the degree of data clustering LOCKs out of solution in a lot of data, what the best locks Thank you a LOCKs out of solution in a lot of data, what the best locks Frequent use of the table, reconstruction here : Create table ... Lock datarows .... [ Closed window ]