A database table space monitoring method

Abstract

The invention discloses a database table space monitoring method, comprising the following steps: pre-setting the specific growth period of the database table space and the minimum usable days warning threshold; regularly collecting the usage of daily table space data volume; taking the latest period as the Collection cycle, extract the daily data growth in the collection cycle, calculate the daily growth benchmark value; calculate the remaining capacity available days N1 according to the current table space remaining size and the daily growth benchmark value; determine whether the remaining capacity available days N1 contains a specific During the growth period, adjust the usable days of the remaining capacity; give an early warning to the table space whose usable days of the remaining capacity reach the warning threshold. The present invention divides the growth of the database table space into a normal business data growth period and a specific growth period, and can accurately and automatically convert the table space utilization rate information into the number of usable days, and realize the daily business data growth and remaining data of each table space. A valid estimate of how many days the capacity can be used.

Description

technical field [0001] The invention relates to a data monitoring method, in particular to a database table space monitoring method. Background technique [0002] With the continuous and stable growth of telecom operators' user scale and the continuous increase of business types, there is a large increase in business volume, and the provincial-level central core business system databases that carry key services, such as account databases and billing databases, are more important. is growing larger. The number of databases continues to increase, the amount of application data continues to grow, and the pressure on the database is increasing. How to effectively control the growth of data volume, respond to the bottleneck of table space usage in a timely manner, and ensure the stable operation of the database system has become the primary support for database operation and maintenance. Target. Most of the existing database table space monitoring solutions are simple informati...

AI Technical Summary

Problems solved by technology

[0005] After receiving the table space usage alarm, the operation and maintenance personnel cannot evaluate the number of days the database table space can be used continuously for this expansion operation. For use, only a small amount of expansion operations can be performed on the table space that reaches the warning threshold based on experience, which will easily lead to an increase in the number of table space alarms and high-frequency expansion operations

[0006] 2. Poor operation and maintenance efficiency

[0007] The operation and maintenance personnel will be tired of continuously paying attention to the usage of many database table spaces and dealing with frequent table space alarms, and once the table space alarms are not handled in time, the database will have serious failures affecting business operations, which will have a great impact on the BOSS business system database May lead to numerous user complaints

[0008] 3. Insufficient resource planning

Due to the lack of analysis basis for daily data growth fluctuations in tablespaces, operation and maintenance personnel can only simply mount a certain number of available devices to the database based on experience, which may lead to unreasonable allocation of available devices

[0010] Obviously, in the face of the high-frequency growth of the business data volume of the supporting system, the traditional information-based monitoring method can no longer meet the needs of precise operation and maintenance. It is imperative to achieve precise operation and maintenance

Images