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...
Gespeichert in:
Hauptverfasser: | , , , , , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
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 |
---|