JP3607574B2 - Transaction processing performance degradation monitoring apparatus and transaction processing performance degradation monitoring method - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a transaction processing performance degradation monitoring apparatus and a transaction processing performance degradation monitoring method.
[0002]
[Prior art]
An example of such a conventional transaction processing performance degradation monitoring apparatus is disclosed in Japanese Patent Laid-Open No. 01-191950.
The transaction processing performance degradation monitoring device disclosed in the publication includes a transaction processing waiting number counting means, a transaction processing waiting number monitoring means, a transaction processing waiting number storage means, a warning message output means, an external display device, It is composed of
[0003]
In such a configuration, the transaction processing performance degradation monitoring apparatus examines the number of transactions waiting for processing counted by the transaction processing waiting number counting unit, and the transaction processing waiting number monitoring unit compares this number with the system allowable transaction registration number. Monitor whether the former exceeds the latter. When the number of waiting for processing exceeds the allowable range, a warning message is output to the external display device.
[0004]
[Problems to be solved by the invention]
The above-described conventional transaction processing performance degradation monitoring device has the following two problems.
The first problem is that when the number of transactions input is small, it is not possible to immediately detect performance degradation. The reason is that even if a problem occurs in the transaction being executed and the next transaction has been in a wait state for a long time due to a delay in processing, the number of transactions that have been put in and the waiting transaction is This is because a warning message is not output unless the set threshold value is reached.
[0005]
The second problem is that if the warning message is overlooked, the monitoring effect is not exhibited. The reason is that this monitoring method merely notifies the operator that the number of waiting for transaction processing has increased by a warning message, and the cause elucidation and problem resolution are left to the operator.
[0006]
The present invention has been made in view of the above problems. Based on the transaction processing information collected at regular intervals, the transaction processing performance deterioration is monitored, and when the transaction processing performance deterioration is recognized, the cause is identified. It is an object of the present invention to provide a transaction processing performance degradation monitoring apparatus and a transaction processing performance degradation monitoring method capable of recovering transaction processing performance by automatically taking appropriate measures.
[0007]
[Means for Solving the Problems]
In order to achieve the above object, the invention according to claim 1 is a transaction processing performance degradation monitoring apparatus that monitors a transaction processing performance degradation based on transaction processing information automatically acquired at regular intervals, and inputs a transaction. And a transaction input control means for registering in the transaction queue and a transaction execution control means for executing a transaction registered in the transaction queue, activated by the transaction input control means, and activated at a predetermined monitoring interval time interval, The transaction processing performance degradation monitoring means for monitoring the processing performance degradation of the transaction executed by the transaction execution means, and the processing performance degradation by the transaction processing performance degradation monitoring means. If, and a transaction stop control means for stopping the running transactions that are causing the performance degradation The transaction processing performance degradation monitoring means determines that the performance is in a degraded state when the transaction processing rate at a certain time falls below a pre-registered performance degradation threshold coefficient. As a configuration.
[0008]
In the invention according to claim 1 configured as described above, there is provided a transaction processing performance degradation monitoring device capable of realizing a function of monitoring transaction processing performance degradation based on transaction processing information automatically acquired at regular intervals. To do. When realizing such a function, the transaction input control means inputs a transaction and registers it in the transaction queue. Then, the transaction input control means is activated. Thus, the transaction execution control means activated by the transaction input control means sequentially executes the transactions registered in the transaction queue. Here, the transaction processing performance degradation monitoring unit is activated at a predetermined monitoring interval time interval, and monitors the processing performance degradation of the transaction executed by the transaction execution unit. Then, the transaction stop control means stops the transaction being executed which is the cause of the decrease in the processing performance when the processing performance deterioration is detected by the transaction processing performance deterioration monitoring means.
[0009]
According to a second aspect of the present invention, in the transaction processing performance deterioration monitoring apparatus according to the first aspect, when the transaction input control means inputs a transaction, the transaction input control means counts the number of transactions and enters the transaction queue. The configuration is to be registered.
In the invention according to claim 2 configured as described above, when a transaction is input by the transaction input control means, the number of transactions is counted and registered in the transaction queue.
[0010]
Furthermore, the invention according to claim 3 is the transaction processing performance degradation monitoring apparatus according to claim 1 or 2, wherein the transaction input control means is configured to execute the transaction processing performance when a transaction is input. The processing performance degradation state monitored by the degradation monitoring means is confirmed, and the input of the input transaction is accepted or rejected according to the processing performance degradation state.
In the invention according to claim 3 configured as described above, when a transaction is input by the transaction input control means, the state of processing performance deterioration monitored by the transaction processing performance deterioration monitoring means is confirmed. Then, the input of the input transaction is accepted or rejected according to the state of the processing performance degradation.
[0011]
Furthermore, the invention according to claim 4 is the transaction processing performance degradation monitoring apparatus according to any one of claims 1 to 3, wherein the transaction processing performance degradation monitoring means is the predetermined monitoring interval time interval. And a timer notification means for generating a control signal, and the transaction processing performance monitoring means is activated in accordance with the control signal of the timer notification means.
In the invention according to claim 4 configured as described above, the transaction processing performance deterioration monitoring means is provided with a timer notification means for generating a control signal at the predetermined monitoring interval time interval. Then, the transaction processing performance monitoring unit is activated according to the control signal of the timer notification unit.
[0012]
Furthermore, the invention according to claim 5 is the transaction processing performance degradation monitoring apparatus according to any one of claims 1 to 4, wherein the transaction processing performance degradation monitoring means records transaction processing status. The information management table is provided.
In the invention according to claim 5 configured as described above, the transaction processing performance deterioration monitoring means is provided with a transaction processing information management table for recording the transaction processing status.
[0013]
In addition, the method for monitoring the degradation in transaction processing performance based on the transaction processing information automatically acquired at regular intervals is not necessarily limited to a substantial device, and it can be easily understood that it also functions as a method. . For this reason, the invention according to claim 6 is a transaction processing performance degradation monitoring method for monitoring the transaction processing performance degradation based on the transaction processing information automatically acquired at regular intervals, wherein a transaction is input and a transaction queue is entered. The transaction input control process registered in the transaction input process, the transaction execution control process started in the transaction input control process and executed in the transaction queue, and the transaction execution started in a predetermined monitoring interval time interval. If the processing performance deterioration monitoring step for monitoring the processing performance deterioration of the transaction executed in the process and the processing performance deterioration in the transaction processing performance deterioration monitoring step, the processing performance And a transaction stop control step of stopping the running transactions causing the reduction The transaction processing performance degradation monitoring step determines that the performance is in a degraded state when the transaction processing rate at a certain time falls below a performance degradation threshold coefficient registered in advance. As a configuration.
That is, it is not necessarily limited to a substantial apparatus, and there is no difference that the method is also effective.
[0014]
DETAILED DESCRIPTION OF THE INVENTION
Next, embodiments of the present invention will be described in detail with reference to the drawings.
FIG. 1 is a block diagram showing the configuration of the embodiment of the present invention.
In the figure, the first embodiment of the present invention includes a transaction input control means 1, a transaction control means 2, a transaction queue 3, a transaction processing performance degradation monitoring means 4, a timer notification means 5, and transaction processing information. It consists of a management table 6. Here, the transaction control means 2 includes a transaction execution control means 2a and a transaction stop control means 2b.
[0015]
Each of these means generally operates as follows. The transaction input control unit 1 determines whether or not a transaction can be input by checking the performance state. If the transaction input is possible and the performance is not deteriorated, the total number of transactions is added, and the input transaction is registered in the transaction queue 3. If the transaction execution control means 2a is not activated, the transaction execution control means 2a is activated.
[0016]
The transaction execution control unit 2a is activated from the transaction input control unit 1 and executes a transaction. When the performance is in a degraded state, the transaction stop control unit 2b stops the transaction being executed. The transaction queue 3 forms a queue for the transaction input control means 1 to register a transaction waiting for execution.
The timer notification means 5 notifies the system time every monitoring interval time registered in advance in the system.
[0017]
The transaction processing performance degradation monitoring unit 4 is activated by the notification of the system time of the timer notification unit 5, acquires a value stored in the transaction processing information management table 6 for recording the transaction execution status, and stores the acquired value. Then, based on the generated transaction processing information management table 6, the transaction processing performance degradation is monitored.
The transaction processing information management table 6 is generated by the transaction processing performance degradation monitoring means 4 and stores the total number of input transactions for each monitoring time, the number of transactions queued, the number of transactions that can be processed, the number of transactions executed, and the transaction processing rate. Yes.
[0018]
Next, the operation of the present embodiment will be described in detail with reference to FIGS.
FIG. 2 is a flowchart showing the processing contents of the transaction input control means 1 of FIG. FIG. 3 is a flowchart showing the processing contents of the transaction execution control means 2a and the transaction stop control means 2b of FIG. FIG. 4 is a flowchart showing the processing contents of the transaction processing performance degradation monitoring means 4 of FIG. FIG. 5 is a diagram showing an aspect of the transaction processing information management table.
[0019]
First, a case where a transaction is input to the transaction input control unit 1 will be described.
In FIG. 2, the transaction input control means 1 first checks whether or not the status flag in the transaction input control means 1 is in a performance degradation state (step S21). If the performance is in a degraded state, the process ends and no transaction input is accepted. On the other hand, if the performance is not degraded, the process proceeds to the next step, and the content of the input transaction cumulative number storage area is incremented by 1 (step S22), and the transaction is registered in the transaction queue (step S23). If the transaction execution control unit 2a has not been activated, the transaction execution control unit 2a is activated (step S24).
[0020]
In FIG. 3, when the transaction execution control means 2a is activated, it is first checked whether or not a transaction is being executed (step S31). If the transaction is not being executed, it is checked whether there is a transaction waiting for execution in the transaction queue 3 (step S35). If there is a transaction waiting for execution, the transaction is extracted from the transaction queue and executed (step S36). If it is determined in step S35 that there is no transaction in the transaction queue 3, the process is terminated.
[0021]
On the other hand, if the transaction is being executed in step S31, it is checked whether or not the state flag in the control means is in a degraded performance state (step S32). If it is not in the degraded state, the process proceeds to step S34, and if it is in the degraded state, the process proceeds to step S33. In step S33, the transaction stop control means 2b is operated to stop the executing transaction, and in step S34, after the transaction ends, the status flag is changed from the performance degradation state to the normal state.
[0022]
On the other hand, the timer notifying unit 5 notifies the transaction processing performance degradation monitoring unit 4 of the system time every time a monitoring interval time registered in the system in advance, and starts the operation of the transaction processing performance degradation monitoring unit 4. Let
[0023]
In FIG. 4, the transaction processing performance degradation monitoring unit 4 that has received the time notification from the timer notification unit 5 first acquires the value of the input transaction storage area added by the transaction input control 1 (step S41). Is stored in the total number 62 of input transactions in the transaction processing information management table 6 shown in FIG. Subsequently, the transaction queue retention count is acquired (step S42), and stored in the transaction queue retention count 63 of the transaction processing information management table 6.
[0024]
Next, the values of the transaction processable number 64, the transaction execution number 65, and the transaction processing rate 66 in the transaction processing information management table 6 are calculated using the previous monitoring information and the values acquired in step S41 and step S42. (Step S43). The formula for calculating the number of transactions that can be processed is 64.
(Number of transactions that can be processed) = (Total number of input transactions)-(Total number of input transactions during previous monitoring) + (Number of transactions queued during previous monitoring)
It becomes.
[0025]
The calculation formula for the number of transaction executions 65 is:
(Transaction execution count) = (Transaction processing count)-(Transaction queue retention count)
And
The formula for calculating the transaction processing rate 66 is:
(Transaction processing rate) = (Number of transactions executed) ÷ (Processing capacity value registered in the system in advance)
It becomes.
The value calculated in this way is stored in the transaction processing information management table 6. The processing capacity value used here is a value that defines the maximum number of transactions to be executed per monitoring interval time registered in advance in the system.
[0026]
Next, the transaction processing rate 66 acquired in step S43 is compared with the performance degradation limit coefficient registered in the system in advance (step S44), and if the transaction processing rate 66 is below the performance degradation limit factor, step Proceed to S45. If the transaction processing rate 66 exceeds the performance degradation limit coefficient, the process proceeds to step S48. In step S45, the number of transaction processable cases 64 is compared with the number of transaction processable cases, and performance degradation is determined. If the transaction processing number is small, it is regarded as a performance degradation state, and the process proceeds to step S46. If the transaction processing number is the same as the transaction processable number, the process proceeds to step S48.
[0027]
If performance degradation is detected continuously, it is determined whether the number of detections is greater than the retry count value registered in advance in the system (step S46). The status flag is set to a performance degradation state (step S47). If performance degradation detection is not continuous in step S46, or if the number of detections is less than the retry count value, the process proceeds to step S48. Then, the transaction queue retention count 63 in the transaction processing information management table 6 is compared with the maximum retention count registered in the system in advance (step S48), and if the transaction queue retention count 63 exceeds the maximum retention count, the performance The process is considered to be in a lowered state, and the process proceeds to step S49.
[0028]
If the transaction queue staying number 63 does not exceed the maximum staying number, the process proceeds to step S51, the internal state flag of the transaction input control unit 1 and the internal state flag of the transaction execution control unit 2a are set to the normal state, and the process is terminated (step S51). S51).
[0029]
Next, in step S49, if performance degradation is detected continuously, it is determined whether or not the number of detections is greater than the retry count value registered in the system in advance. Set the internal status flag to the degraded state. If the performance degradation detection is not continuous in step S49, or if the number of continuous times is less than the retry count value, the process is terminated.
[0030]
Next, the effect of this embodiment will be described.
In this embodiment, since the transaction processing performance degradation is detected by simultaneously monitoring the transaction processing rate and the number of transactions waiting to be executed, it is possible to detect immediately when a transaction processing performance degradation occurs. . In addition, since the cause of the transaction processing performance degradation can be automatically identified and the cause can be removed, the system can be operated without intervention by the operator even when the performance degradation occurs.
[0031]
Next, the operation of the embodiment of the present invention will be described in detail using an example of the transaction processing information management table 6.
As described above, FIG. 5 shows one mode of the transaction processing information management table 6.
Here, the following values are registered in advance in the system: monitoring interval time = 10 seconds, maximum stay count = 200, processing capacity value = 100, performance degradation limit coefficient = 20%, retry count = 5 times Shall.
For example, consider time a in the transaction processing information management table 6. Time a is the time when the first transaction processing performance degradation was monitored after the transaction processing system was operated.
Transactions entered from the transaction input control means 1 are registered in the transaction queue 3 by the transaction input control 1 until the time a is reached after the transaction processing system starts operating, and executable transactions are executed by the transaction execution control means 2a. It is running.
[0032]
The timer notifying unit 5 notifies the transaction processing performance degradation monitoring unit 4 of the time a at time a. The transaction processing performance degradation monitoring unit 4 starts processing upon receiving the notification of time a from the timer notification unit 5, and, as shown in FIG. 4, the transaction processing information management of FIG. 5 is performed through steps S41, S42, and S43. The total number of input transactions “10”, the number of transactions queued at “0”, the number of transactions that can be processed “10”, the number of transactions that can be executed “10”, and the transaction processing rate “10” in Table 6 are acquired and Store in the management table 6.
[0033]
In the determination of step S44 in FIG. 4, in this example, the transaction processing rate is below the performance degradation limit coefficient 20%, and there is a possibility of performance degradation. Further, in step S45, the transaction processable number and the transaction process number are compared. Since both are “10”, the process proceeds to step S48. In step S48, the transaction staying number is compared with the maximum staying number. Since the transaction staying number is “0” and the maximum staying number is 200, it is determined that the performance has not deteriorated.
[0034]
For example, consider the time c in the transaction processing information management table 6. The transaction processing performance degradation monitoring unit 4 starts the processing upon receiving the notification of time c from the timer notification unit 5, and the transaction processing information management table 6 in FIG. 5 is processed by steps S 41, S 42 and S 43 in FIG. The total number of input transactions “250”, the number of transaction queue stays “150”, the number of transactions that can be processed “160”, the number of transactions executed “10”, and the transaction processing rate “10” are acquired at the time c, and the transaction processing information management table 6 To store.
[0035]
In the determination at step S44 in FIG. 4, the transaction processing rate is lower than the performance degradation limit coefficient 20% even in this example, and there is a possibility of performance degradation. Next, in step S45, the transaction processable number is compared with the transaction process number. Since the transaction process number “10” is less than the transaction processable number “160”, it is determined that performance degradation has occurred and the process proceeds to step S46. move on.
[0036]
In step S46, the number of performance degradation detections is checked and compared with a retry count of 5. In this example, if the number of performance degradation detections is 5 or less consecutively, the process proceeds to step S48, where the transaction queue retention count “150” is compared with the maximum retention count “200”, and there is no performance degradation. Considered. In this example, if the performance degradation detection exceeds five consecutive times, the internal state flag of the transaction execution control means is changed to the performance degradation state in step S47, and the process is terminated. At this time, as shown in FIG. 3, the transaction process execution control unit 2a determines the status flag in step S32, and if it is recognized that the performance is in a degraded state, the transaction process execution control unit stops the executing transaction in step S33. Thereafter, in step S34, the state flag is returned to the normal state, and the transaction execution process is continued.
[0037]
For example, consider the time m in the transaction processing information management table 6. The transaction processing performance degradation monitoring unit 4 starts processing upon receiving the notification of the time m from the timer notification unit 5, and, as shown in FIG. 4, the transaction processing information management of FIG. 5 is performed through steps S41, S42, and S43. The total number of input transactions “2000”, the number of transaction queue retention “220”, the number of transactions that can be processed “310”, the number of transactions executed “90”, and the transaction processing rate “90” are acquired and transaction processing information is obtained. Store in the management table 6.
[0038]
In the determination in step S44 of FIG. 4, in this example, the transaction processing rate exceeds the performance degradation limit coefficient 20%, so the process proceeds to step S48. In step S48, the transaction queue staying number “220” is compared with the maximum staying number “200”, and it is determined that a performance drop has occurred. In the next step S49, the number of times the performance drop is detected is checked, and a retry is performed. Compare with 5 counts.
In this example, if the performance degradation detection is less than 5 consecutive times, the processing is terminated as it is. If it is greater than 5 consecutive times, the internal status flag of the transaction input control means 1 is set to the performance degradation status in step S50 and the processing is terminated. At this time, as shown in FIG. 2, when the transaction is input, the transaction input control means 1 determines the status flag in step S21. I will refuse.
[0039]
Next, consider time n in the transaction processing information management table 6. The time n is the monitoring time next to the example time m. In monitoring at the time n in the transaction processing performance degradation monitoring control means 4, the total number of input transactions “2000”, the number of transaction queues “130”, and the number of transactions that can be processed “220” in the transaction processing information management table 6 of FIG. The transaction execution count “90” and the transaction processing rate “90” are acquired and stored in the transaction processing information management table 6.
In this example, neither the determination in step S44 nor the determination in step S48 determines that the performance has deteriorated. Therefore, the transaction input control means internal state flag that has been in the deteriorated state by the previous monitoring is changed to the normal state in step S51. The At this time, when a transaction is input, the transaction input control means 1 determines the status flag in step S21 from FIG. 2, and if it is recognized that the performance is not degraded, the processing after step S22 is executed to resume the transaction input. To do.
[0040]
As a result, when an abnormality occurs in the transaction being executed and the transaction processing performance is degraded, the transaction processing is detected by detecting the performance degradation, identifying the transaction in which the abnormality has occurred, and stopping the transaction. Performance recovery can be performed without an operator. In addition, when a transaction performance degradation occurs due to a large number of transactions, the performance degradation can be detected and recovered without causing any transaction to be detected without intervention.
[0041]
【The invention's effect】
As described above, the present invention monitors the transaction processing performance degradation based on the transaction processing information collected at regular intervals, identifies the cause of the transaction processing performance degradation, and automatically identifies the cause. It is possible to provide a transaction processing performance deterioration monitoring apparatus capable of recovering transaction processing performance by taking appropriate measures.
According to the second aspect of the invention, since transactions are counted, it is possible to execute control according to the count number.
Furthermore, according to the third aspect of the present invention, in the case of a state where the processing performance is deteriorated, it is possible to prevent further processing performance deterioration by newly rejecting the input of the transaction.
[0042]
Furthermore, according to the fourth aspect of the present invention, it is possible to activate the transaction processing performance deterioration monitoring means by a simple method.
Furthermore, according to the fifth aspect of the present invention, it becomes possible to grasp the transaction processing status by a simple method.
Furthermore, according to the invention of claim 6, based on the transaction processing information collected at regular intervals, the transaction processing performance degradation is monitored, and when the transaction processing performance degradation is recognized, the cause is identified, It is possible to provide a transaction processing performance degradation monitoring method capable of recovering transaction processing performance by automatically taking appropriate measures.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of a first exemplary embodiment of the present invention.
FIG. 2 is a diagram showing a flowchart of a transaction input control means in FIG. 1 of the present embodiment.
FIG. 3 is a diagram showing a flowchart of a transaction execution control unit in FIG. 1 of the present embodiment.
FIG. 4 is a diagram showing a flowchart of transaction processing performance degradation monitoring means in FIG. 1 of the present embodiment.
5 is a diagram showing an example of a transaction processing information management table in FIG. 1 according to the present embodiment.
[Explanation of symbols]
1 Transaction input control means
2 Transaction control means
2a Transaction execution control means
2b Transaction stop control means
3 Transaction queue
4 Transaction processing performance degradation monitoring means
5 Timer notification means
6 Transaction processing information management table
61 Monitoring time
62 Cumulative number of input transactions
63 Number of transactions queued
64 Number of transactions that can be processed
65 Transaction execution count
66 Transaction processing rate

Claims (6)

A transaction processing performance degradation monitoring device that monitors transaction processing performance degradation based on transaction processing information automatically acquired at regular intervals,
Transaction input control means for entering a transaction and registering it in a transaction queue;
Transaction execution control means that is activated by the transaction input control means and executes a transaction registered in the transaction queue;
Transaction processing performance degradation monitoring means that monitors a processing performance degradation of a transaction that is started at a predetermined monitoring interval time interval and executed by the transaction execution means;
A transaction stop control means for stopping a transaction being executed that causes a decrease in the processing performance when the transaction processing performance drop monitoring means causes a drop in the processing performance ;
The transaction processing performance degradation monitoring device, wherein the transaction processing performance degradation monitoring means determines that the performance is in a degraded state when a transaction processing rate at a certain time falls below a performance degradation threshold coefficient registered in advance . In the transaction processing performance degradation monitoring device according to claim 1,
A transaction processing performance degradation monitoring apparatus, wherein the transaction input control means registers a transaction in the transaction queue while counting the number of transactions when inputting the transaction. In the transaction processing performance degradation monitoring apparatus according to claim 1 or 2,
When the transaction is input, the transaction input control means checks the processing performance degradation state monitored by the transaction processing performance degradation monitoring means, and accepts the input of the input transaction according to the processing performance degradation status. Alternatively, a transaction processing performance degradation monitoring apparatus characterized by rejecting input. In the transaction processing performance degradation monitoring apparatus according to any one of claims 1 to 3,
The transaction processing performance degradation monitoring means includes timer notification means for generating a control signal at the predetermined monitoring interval time interval, and the transaction processing performance monitoring means is activated according to the control signal of the timer notification means. A transaction processing performance degradation monitoring device as a feature. In the transaction processing performance degradation monitoring apparatus according to any one of claims 1 to 4,
The transaction processing performance deterioration monitoring device comprises a transaction processing information management table for recording a transaction processing status. A transaction processing performance degradation monitoring method for monitoring transaction processing performance degradation based on transaction processing information automatically acquired at regular intervals,
A transaction input control process for entering a transaction and registering it in the transaction queue;
A transaction execution control step that is started in the transaction input control step and executes a transaction registered in the transaction queue, and a transaction process that is started in a predetermined monitoring interval time interval and executed in the transaction execution step Transaction processing performance degradation monitoring process for monitoring performance degradation;
A transaction stop control step for stopping a running transaction that causes the processing performance degradation when the processing performance degradation monitoring step causes the processing performance degradation ;
The transaction processing performance degradation monitoring step is a transaction processing performance degradation monitoring method for determining that the transaction processing performance at a certain time is in a performance degradation state when a transaction processing rate at a certain time falls below a performance degradation threshold coefficient registered in advance .

Images