| Event Information | CAUSE:
The LOCK_TIMEOUT setting allows an application to set a maximum time that a statement waits on a blocked resource. When a statement has waited longer than the LOCK_TIMEOUT setting, the blocked statement is canceled automatically, and error message 1222, "Lock request time-out period exceeded," is returned to the application.
RESOLUTION:
If you receive this error from your application, search your code for the LOCK_TIMEOUT value and consider adjusting the setting to meet the needs of your environment.
For more information on the LOCK_TIMEOUT setting, see "Customizing the Lock Time-Out" in Books Online. |
