Case Scenario: Optimizing Locking
In this scenario, you are a database developer in your organization. An order entry application contains various elements that list the database contents. During peak usage, the lists frequently take longer than usual to display, even though they don’t contain a lot of data. You have noticed that these delays are caused by blocking. The order entry application also contains several reports that display aggregated sales information. When these reports are double-checked by auditors, they are sometimes found to contain inconsistent data. The values displayed at one place in a report might not be consistent with data in other places of the report.
The application currently uses the default transaction isolation level and does not use locking hints. Design a solution for both problems by implementing the appropriate transaction isolation level.
© Microsoft. All Rights Reserved.