Sometimes during a production site slowdown, DBAs notice a very high amount of row level locking on the Orders tables. Then, lacking any other evidence, the locking is thought to be the root cause of the production issue. Although this can be possible, in practice, in almost every situation locking on the Orders tables is a side-effect.
This is why: Let's say the site is running normally and responsive. Then, all of the sudden, the site becomes slow. Shoppers become impatient and start to double-click. These users manage to now... [Continue Reading]