Method for precisely calculating DB performance data and DB monitoring device for calculating DB performance data

摘要

A DB monitoring device for ultra-precise calculation of DB performance data and DB performance data is provided. The DB performance data ultra-precise calculation method of the DB monitoring device that manages the performance of the DB using a DBMS (Database Management System) is: (A) When the DB monitoring device connects to the DBMS and creates a session, the shared memory Storing a plurality of performance views that record session-related information in (B) the DB monitoring device periodically polls the session monitoring table identified by the session ID (SID) among the plurality of performance views. In order to calculate the DB performance data among the session-related information, collecting session monitoring information previously designated, and the DB monitoring device analyzes the session monitoring information collected in step (B) and includes the SQL elapsed time of the session. It may include the step of calculating the DB performance data.