Database Code-Module Performance and Reliability Metrics Instrumentation

摘要

Novel tools and techniques for instrumenting code-module execution within a database (or within a plurality of databases). In one aspect, various embodiments can instrument (e.g., measure and/or monitor) database applications, jobs, or other coded modules, execution steps, and/or any other type of executable code within (or even outside) of a database to accurately track execution and call lineage, timings, and/or errors within database code modules, long-running SQL statements, or other large database calls/callouts initiating from within one or more databases, across one or more platforms (e.g., Oracle, SQL Server, etc.). In another aspect, certain embodiments can perform such instrumentation through a variety of interfaces (intra-database calls, database links, linked servers, external application code, etc.).

主权项

1. A method for measuring database code-module performance and reliability, the method comprising:
receiving, in a database management system, a call to a set of executable code within a database managed by the database management system; determining, in the database management system, that the set of executable code should be instrumented to measure performance of the set of executable code; invoking, with an executing instance of the set of executable code in the database management system, the measurement function, based at least in part on a determination that the set of executable code should be instrumented; collecting, with the measurement function, metric data about execution of the set of executable code, the metric data including a start time of the executing instance of the set of executable code; storing, with the measurement function, the metric data in a table in the database; associating, in the database, a unique identifier with the executing instance of the set of executable code and the metric data; returning, with the measurement function, an identifier string to the executing instance of the set of executable code, the identifier string corresponding to the unique identifier; passing, with the executing instance of the set of executable code, the identifier string to the measurement function at completion of execution of the set of executable code; adding, with the measurement function, a stop time to the metric data in the database, based on receipt of the identifier string from the executing instance of the set of executable code.