how to resolve deadlock in sql server

3 is opened globally. with No_InfoMsgs: When the command contains this parameter, disable DBCC to output informative messages ============================================== =========================================================== */-- Trace 1222 the detailed deadlock information can be returned to the SQL Server log-flag-1 indicates that the trace flag 1222 s

be converted to the exclusive (x) lock, and each transaction waits for another transaction to release the share mode lock, a deadlock occurs. To avoid this potential deadlock problem, use the update (u) Lock. Only one transaction can obtain the resource Update (u) Lock at a time. If the transaction modifies the resource, the update (u) Lock is converted to the row (x) Lock. Otherwise, the lock is convert

transaction attempts to obtain the row lock (x) for update. Because both transactions need to be converted to the exclusive (x) lock, and each transaction waits for another transaction to release the share mode lock, a deadlock occurs. To avoid this potential deadlock problem, use the update (u) Lock. Only one transaction can obtain the resource Update (u) Lock at a time. If the transaction modifies t

of threads = maximum number of connections +5, so as to maximize the efficiency; otherwise, the thread pool of SQL Server is enabled by using the number of compounding threads 45, in a certain order to visit your table. If you lock table a first and then lock table B, then lock them in this order in all stored procedures. If you (inadvertently) lock table B in a stored procedure and then lock table A, this

the transaction. This isolation level is valid for the SQL server connection (not the current transaction) until the next time you use this command to set a new isolation level. Active locks and deadlocksNext we will discuss the special cases of locks: Suppose T1 needs to update R1 and R2. First, it locks R1, And the other transaction T2 also needs to update R2 and R1. First, it locks R2. At this time, t1

We do the management software, the main core is in the data storage management. So database design is our priority. In order to make our management software stable, scalable, excellent performance, traceable troubleshooting, upgradeable deployment, plug-in operation, we often develop our own management software development platform. We always want to learn other people's development platform (such as UF or Kingdee or SAP), but we always lament the management software business processing a wide r

1. Database Replication SQL Server 2008 database replication synchronizes data between multiple servers through the publishing/subscription mechanism. We use this mechanism for Synchronous database backup. The synchronous backup here refers to the real-time data synchronization between the backup server and the master server