DBMS SQL APPLICATION SQL PERFORMANCE ANALYSIS SYSTEM AND METHOD IN DBMS SECTION USING THE SAME

摘要

The present invention relates to a performance analysis system that provides transaction-based SQL performance analysis information. The performance analysis system of the present invention provides a database for SQL processing of an application, A collection and storage unit that starts an API (Application Programming Interface) by a trigger, collects the performance data of each SQL unit between the start time and the end time of each transaction from the database and stores it in a repository, and the stored in the repository and an analysis information providing unit that analyzes performance data and provides performance analysis information for each transaction or each SQL unit.