A data access monitoring device

Abstract

The invention discloses a monitoring device for data access. The monitoring device for data access comprises a centralized configuration module: for configuring a monitored-host list, acquisition monitoring items, acquisition time, an acquisition format and a correspondence between a service module and an SQL statement; a uniform acquisition module: for acquiring related metadata in real time according to configuration information of the centralized configuration module, and sending the metadata to a quality analyze module for real-time analysis; and the quality analyze module: for collecting statistics of a database use and access status and a system resource consumption status according to the acquired metadata, and optimizing database use and access that causes abnormal system resource consumption. According to the monitoring device for data access, the service volume and host resource use status are acquired and monitored in real time, and a capacity expansion demand and an optimization demand are estimated accurately with reference to the historical change trend of the service volume, so that resource consumption becomes clear and the capacity expansion demand and the optimization demand are predictable. Therefore, the failure rate and management cost are greatly reduced and the system stability is improved.

Description

technical field [0001] The invention relates to a data processing device, in particular to a data access monitoring device. Background technique [0002] The existing IT system data of large and medium-sized enterprises is mainly stored in the database, and the data generated during business operations is stored in the database through persistence. Data can never be original. Data is always constructed according to someone's preferences and values, such as configuration data. When the system starts, it needs to read the configuration data for initialization. The configuration data is constructed along with the business system , and become an integral part of the system. The reading and modification of data is called data access, and the access quality presented by different data access methods is also different. [0003] The quality of data access in the database includes not only the way of data access, but also the efficiency of data access. Data access methods include ...

AI Technical Summary

Problems solved by technology

Although this method can comprehensively score SQL in the standard latitude, the score has a great chance of losing its authenticity because it is not combined with the actual situation, and because it is not combined with the real load, it will lead to some qualified SQL variables in the scoring rules. hidden dangers of the system

[0009] Method 2: Query the historical situation through the Automatic Workload Repository (AWR), and then optimize the TOP SQL that has problems. Although the system problems can be solved, there is no way to solve the system data after the problem occurs. The role of access control

And wait until the problem occurs before intervening to deal with it, so that the operation and maintenance are in a passive state, which is not conducive to the stable operation of the system, and even the operation and maintenance are out of control, resulting in the system crashing for a long time

Images