Database performance data acquisition method and system

The invention relates to a database performance data collection method and system, and the method comprises the steps: data collection: collecting snapshot data from a production database, and storing the snapshot data in a snapshot database; data processing: obtaining and determining a data process...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: XING YINGXIN, SHI RUI, WANG JING, HUANG WEILAN, LU QIANG, CHEN TIANXIN, SHEN XINYI, QIAN CHENG, WANG KE
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention relates to a database performance data collection method and system, and the method comprises the steps: data collection: collecting snapshot data from a production database, and storing the snapshot data in a snapshot database; data processing: obtaining and determining a data processing rule of each database according to the operation delay time of the last round of processing operation, extracting snapshot data from the snapshot database according to the processing proportion and the processing interval of the data processing rule, calculating a difference value, and storing the difference value in a database performance analysis data warehouse; and data compensation: acquiring processing operation information of degraded operation, performing data processing again according to the snapshot data to generate compensation data, replacing corresponding data in the database performance analysis data warehouse with the compensation data, and deleting expired snapshot data. Compared with the prior