Conclusion


The database administrator has answered most of the questions posed at the start of this scenario. The only unknown question is why the system suddenly encountered this slowdown after performing normally, and what changed to trigger this problem. The database administrator contacts the production team and finds out that a sales promotion has driven workload to unprecedented levels. The database administrator concludes that this sharp increase in transaction volume led to more locks being requested for rows in the INVENTORY table.

Summary


ObjectiveMonitoring Report Used
Step 1:Determining the problem categoryMONREPORT.DBSUMMARY
Step 2:Performing detailed diagnosis appropriate locking problemsMONREPORT.DBSUMMARY
Step 3:Identifying the scope of the SQL statements involvedMONREPORT.LOCKWAIT