MANAGEMENT OF BOTTLENECKS IN DATABASE SYSTEMS

摘要

Management is provided for threads of a database system that is subject to a plurality of disparate bottleneck conditions for resources. A monitor thread retrieves, from a first thread, first monitor data for first bottleneck condition of a first type. The monitor thread compares the first monitor data to a trigger level for the first bottleneck condition and then determines, in response to the comparison of the first monitor data to the trigger level, a potential source of the first bottleneck condition. A potential blocker thread is identified based upon the potential source of the first bottleneck condition. The monitor thread retrieves, from the potential blocker thread, second monitor data for a second type of bottleneck condition that is different from the first type of bottleneck condition. Based upon monitor data, a blocking thread is identified, and a particular blocking solution is applied to the blocking thread.

主权项

1. A system for managing threads designed to access resources for a database system and subject to a plurality of disparate bottleneck conditions for resources, the system comprising a computer configured to use at least one monitor thread to:
retrieve, from a first thread, first monitor data for first bottleneck condition of a first type; compare the first monitor data to a trigger level for the first bottleneck condition; determine, in response to the comparison of the first monitor data to the trigger level, a potential source of the first bottleneck condition; identify a potential blocker thread based upon the potential source of the first bottleneck condition; retrieve, from the potential blocker thread, second monitor data for a second type of bottleneck condition that is different from the first type of bottleneck condition; identify, based upon the second monitor data, a blocking thread; and apply a particular blocking solution to the blocking thread.