![]() Consider using snapshot isolation or read committed snapshot isolation to allow readers to not take S/IS locks and reduce blocking.Consider creating nonclustered indexes to remove row locks from the underlying heap/clustered index.Look for application code that will cause locks to be acquired and then waits for user input, or fails to commit a transaction for a long time.Look for code that specifies a TABLOCK (causes a table Shared lock) or TABLOCKX (causes a table Exclusive lock) hint. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |