Database cost tracing and analysis

摘要

Web services hosted at a data center may employ architectural patterns that tend to obfuscate the source of queries made against databases and other resources in the data center. The queries may be the source of performance, capacity or utilization problems, and may contribute to the cost of hosting the web service. Web service invocations may be associated with identifiers that can be included in modified queries sent to databases and other resources. Summarized cost information may be calculated based on recorded associations between the identifiers and query performance information.

主权项

1. A non-transitory computer-readable storage medium having stored thereon instructions that, upon execution by a computing device, cause the computing device to at least:
initiate processing of an invocation of an application programming interface; associate a first identifier with a thread of execution performing at least one function of the application programming interface; create a second query from a first query, the first query corresponding to performing the at least one function of the application programming interface, the second query comprising the first identifier, the second query configured to produce a same result upon execution as the first query; and cause the second query to be executed.