Zendesk, Inc.
CONSERVING COMPUTER RESOURCES THROUGH QUERY TERMINATION

Abstract:

A query terminator executes within a computing environment featuring multiple applications and/or services that access a shared database, and operates to interrupt, halt, or terminate processes (e.g., queries) that misbehave in order to conserve computing resources. Illustrative misbehavior includes execution for an excessive period of time. Queries submitted by the applications/services are tagged to identify their origin, responsible teams, endpoints, resources, and/or other metadata. Queries that are susceptible to forced termination are also tagged with timeout values. The query terminator for a given application or service identifies queries from the application that are currently executing on the database, examines their metadata, and interrupts or terminates those that have been executing longer than their timeout values. Metadata regarding terminated processes is logged and provided to the responsible teams.