Database table space monitoring method

Abstract

The invention discloses a database table space monitoring method. The method comprises the steps that a specific growth period and an alarm threshold valve of minimum available days of database table space are set in advance; the using conditions of a daily table space data volume is acquired regularly; a latest period serves as an acquisition cycle, the daily data growth amount during the acquisition cycle is extracted, and a reference value of the daily growth amount is calculated; the number N1 of the available days of a surplus capacity is calculated according to the surplus size of the current table space and the reference value of the daily growth amount; a judgment is conducted on the number N1 of the available days of the surplus capacity to see if the specific growth period is included, and the available days of the surplus capacity are adjusted; the table space with the available days of the surplus capacity reaching the alarm threshold valve is subjected to early warning. According to the database table space monitoring method, the table space usage rate information can be automatically transformed into the available days accurately by dividing the database table space growth into a normal business data growth period and the specific growth period, so that effective assessments of the daily business data growth amount and the available days of the surplus capacity of all the current table space are achieved.

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