CN107908533B - A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index - Google Patents
A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index Download PDFInfo
- Publication number
- CN107908533B CN107908533B CN201710454882.2A CN201710454882A CN107908533B CN 107908533 B CN107908533 B CN 107908533B CN 201710454882 A CN201710454882 A CN 201710454882A CN 107908533 B CN107908533 B CN 107908533B
- Authority
- CN
- China
- Prior art keywords
- index value
- performance index
- performance
- indicator
- performance indicator
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/32—Monitoring with visual or acoustical indication of the functioning of the machine
- G06F11/323—Visualisation of programs or trace data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
- G06F11/3419—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment by assessing time
- G06F11/3423—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment by assessing time where the assessed time is active or idle time
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3452—Performance evaluation by statistical analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3466—Performance evaluation by tracing or monitoring
- G06F11/3476—Data logging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/81—Threshold
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/865—Monitoring of software
Abstract
The embodiment of the invention discloses a kind of monitoring methods of database performance index, this method comprises: the incidence relation between the performance indicator and database dimension of creation database;Each performance indicator is acquired in the corresponding sub- performance index value in different dimensions place;Sub- performance index value of the same performance index at different dimensions is added up to obtain the current performance index value of the performance indicator;Multiple historical performance index values corresponding to each performance indicator are obtained, the historical performance index value is corresponding with the current performance index value;The current performance index value of the performance indicator is analyzed according to the historical performance index value and preset algorithm of each performance indicator to obtain analysis result.The embodiment of the invention also discloses monitoring device, computer readable storage medium and the equipment of a kind of database performance index.The concentration that the embodiment of the present invention can carry out multi-dimensional data to the performance indicator of database is analyzed, to carry out trend analysis and abnormal judgement.
Description
Technical field
The present invention relates to data-base performance monitoring technical field more particularly to a kind of monitoring sides of database performance index
Method, device, computer readable storage medium and equipment.
Background technique
It is very extensive in enterprise's application based on the application system of database, since the performance issue of database causes to apply
Situations such as system low-response, happens occasionally.Therefore, the performance condition in daily O&M for database accomplishes periodically to collect
Statistical information is very important.However, although existing APM analysis tool can provide the performance index value of database,
Lack the analytical judgment to performance index value, so that inconvenient carry out trend analysis and abnormal judgement.
Summary of the invention
The embodiment of the present invention provides a kind of monitoring method of database performance index, device, computer readable storage medium
And equipment, the concentration that multi-dimensional data can be carried out to the performance indicator of database is analyzed, to carry out trend analysis and different
Often judgement.
In a first aspect, the embodiment of the invention provides a kind of monitoring method of database performance index, this method comprises: wound
Build the incidence relation between the performance indicator of database and database dimension;It is right to acquire each performance indicator institute at different dimensions
The sub- performance index value answered;Sub- performance index value of the same performance index at different dimensions is added up to obtain the performance indicator
Current performance index value;Obtain multiple historical performance index values corresponding to each performance indicator, the historical performance index
It is worth corresponding with the current performance index value;According to the historical performance index value and preset algorithm of each performance indicator point
The current performance index value of the performance indicator is analysed to obtain analysis result.
Second aspect, the embodiment of the invention provides a kind of monitoring device of database performance index, which includes wound
Unit is built, for creating the incidence relation between the performance indicator of database and database dimension;Acquisition unit, it is every for acquiring
One performance indicator is in the corresponding sub- performance index value in different dimensions place;Summing elements are used for same performance index in difference
Sub- performance index value at dimension is cumulative to obtain the current performance index value of the performance indicator;Acquiring unit, it is every for obtaining
Multiple historical performance index values corresponding to one performance indicator, the historical performance index value and the current performance index value phase
It is corresponding;Analytical unit is analyzed the performance for the historical performance index value and preset algorithm according to each performance indicator and is referred to
Target current performance index value is to obtain analysis result.
The third aspect, the embodiment of the invention provides a kind of computer readable storage medium, the storage medium has one
Perhaps more than one program this or more than one program can be executed by one or more than one processor to realize
Following steps: the incidence relation between the performance indicator of database and database dimension is created;Each performance indicator is acquired not
The corresponding sub- performance index value with dimension place;Sub- performance index value of the same performance index at different dimensions is added up to obtain
To the current performance index value of the performance indicator;Multiple historical performance index values corresponding to each performance indicator are obtained, it is described
Historical performance index value is corresponding with the current performance index value;According to the historical performance index value of each performance indicator
And preset algorithm analyzes the current performance index value of the performance indicator to obtain analysis result.
Fourth aspect, the embodiment of the invention provides a kind of monitoring device of database performance index, the equipment includes:
Memory and processor;The memory is for storing at least one computer program;The processor reads the storage
Computer program in device is to execute following operation: creating being associated between the performance indicator of database and database dimension
System;Each performance indicator is acquired in the corresponding sub- performance index value in different dimensions place;By same performance index in different dimensions
The sub- performance index value at place is cumulative to obtain the current performance index value of the performance indicator;It obtains corresponding to each performance indicator
Multiple historical performance index values, the historical performance index value are corresponding with the current performance index value;According to each performance
The historical performance index value and preset algorithm of index analyze the current performance index value of the performance indicator to obtain analysis knot
Fruit.
The incidence relation between performance indicator and database dimension that the embodiment of the present invention passes through creation database, and then adopt
Collect each performance indicator in the corresponding sub- performance index value in different dimensions place, then by same performance index at different dimensions
Sub- performance index value it is cumulative to obtain the current performance index value of the performance indicator, and obtain corresponding to each performance indicator
Multiple historical performance index values analyze the corresponding current performance of each performance indicator according to historical performance index value and preset algorithm
Index value is to obtain analysis result.The concentration that the embodiment of the present invention can carry out various dimensions to the performance indicator of database is analyzed,
To carry out trend analysis and abnormal judgement.
Detailed description of the invention
Technical solution in order to illustrate the embodiments of the present invention more clearly, below will be to needed in embodiment description
Attached drawing is briefly described, it should be apparent that, drawings in the following description are some embodiments of the invention, general for this field
For logical technical staff, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is the flow diagram of the monitoring method of database performance index provided in an embodiment of the present invention;
Fig. 2 is the sub-process schematic diagram of S105 in Fig. 1;
Fig. 3 is the sub-process schematic diagram of S203 in Fig. 2;
Fig. 4 be another embodiment of the present invention provides database performance index monitoring method flow diagram;
Fig. 5 is the monitoring figure that CPU provided in an embodiment of the present invention uses the time;
Fig. 6 is the monitoring figure of I/O waiting time provided in an embodiment of the present invention;
Fig. 7 is the monitoring figure of Lock waiting time provided in an embodiment of the present invention;
Fig. 8 is the schematic block diagram of the monitoring device of database performance index provided in an embodiment of the present invention;
Fig. 9 is the schematic block diagram of analytical unit in Fig. 8;
Figure 10 is the schematic block diagram of judging unit in Fig. 9;
Figure 11 be another embodiment of the present invention provides database performance index monitoring device schematic block diagram;
Figure 12 is the schematic block diagram of the monitoring device of database performance index provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
It should be appreciated that ought use in this specification and in the appended claims, term " includes " and "comprising" instruction
Described feature, entirety, step, operation, the presence of element and/or component, but one or more of the other feature, whole is not precluded
Body, step, operation, the presence or addition of element, component and/or its set.
It is a kind of flow diagram of the monitoring method of database performance index provided in an embodiment of the present invention referring to Fig. 1.
As shown, the monitoring method of the database performance index includes step S101~S105.
S101 creates the incidence relation between the performance indicator of database and database dimension.
Specifically, in embodiments of the present invention, performance indicator includes (Central Processing Unit, the center CPU
Processor) use time, I/O (input/output, input/output end port) waiting time, Lock waiting time.It is understood that
The performance indicator on ground, database is not limited thereto, such as can also include disk occupancy, memory usage.Dimension is several
According to the organized hierarchical structure for the classification for being used to describe data in library, these classification and structure describe some similar member's collection
It closes, can will be analyzed based on these member sets.As in embodiments of the present invention, dimension may include SQL, EVENT,
OBJECT and USER etc..Wherein, SQL is structured query sentence, and EVENT is event, and OBJECT is object, in database
Object can be table, storing process, function, view etc., and USER is user.It is to be appreciated that in some other embodiments, dimension
Degree can also include INSTANCE example.
Create database performance indicator and database dimension between incidence relation when, table structure next life can be passed through
At.CPU can such as be used time, I/O waiting time, Lock waiting time as the list of table, by database dimension SQL,
The row item of EVENT, OBJECT, USER as table, so that realizing is associated database dimension and performance indicator.It is understood that
Ground, in some other embodiment, the performance indicator of database and the incidence relation of dimension are not limited to the form of table structure.
S102 acquires each performance indicator in the corresponding sub- performance index value in different dimensions place.
Specifically, as described above, each performance indicator is corresponding with respective sub- performance index value at different dimensions, such as
Using the time, the corresponding sub- performance index value at different dimensions includes that SQL, EVENT, OBJECT and USER are respectively corresponded to CPU
Sub- performance index value;I/O waiting time corresponding sub- performance index value at different dimensions include SQL, EVENT, OBJECT,
And the corresponding sub- performance index value of USER;Lock waiting time corresponding sub- performance index value at different dimensions includes
The corresponding sub- performance index value of SQL, EVENT, OBJECT and USER.
S103 adds up sub- performance index value of the same performance index at different dimensions to obtain working as the performance indicator
Preceding performance index value.
Specifically, current performance index value is used to indicate the current runnability of database, by acquiring each individual character
Can index characterized in the sum of corresponding sub- performance index value in different dimensions place.In embodiments of the present invention, according to creation
The performance indicator of database and the incidence relation of dimension and collected each performance indicator are in the corresponding son in different dimensions place
Performance index value obtains the current performance index value of different performance index.I.e. collected CPU using the time dimension SQL,
EVENT, OBJECT, USER virgin's performance index value are added up to obtain the current performance index value that CPU uses the time, and will
The current performance index value is labeled as X1;The collected I/O waiting time is in dimension SQL, EVENT, OBJECT, USER virgin's property
Energy index value is added up to obtain the current performance index value of I/O waiting time, and the current performance index value is labeled as
X2;The collected Lock waiting time is added up in dimension SQL, EVENT, OBJECT, USER virgin's performance index value to obtain
X3 is labeled as to the current performance index value of Lock waiting time, and by the current performance index value.The current performance index value
Characterize the performance index value of current time database, such as performance index value of 3/3 11 points of database of the morning in 2017.
S104, obtains multiple historical performance index values corresponding to each performance indicator, the historical performance index value with
The current performance index value is corresponding.
Specifically, in embodiments of the present invention, historical performance index value is corresponding with current performance index value.The history
Energy index value is sub- performance index value the sum of of each performance indicator of preset quantity at different dimensions.Such as acquisition database
11 points of each performance indicators of every morning are in the corresponding sub- performance index value in different dimensions place between 2017 2/3~3/3, and
The historical performance index value of the preset quantity is obtained according to the sub- performance index value of acquisition.
S105 analyzes working as the performance indicator according to the historical performance index value and preset algorithm of each performance indicator
Preceding performance index value is to obtain analysis result.
Specifically, in order to which whether the currency index value for judging database is normal, in embodiments of the present invention, according to each
The corresponding historical performance index value of performance indicator and preset algorithm analyze the current performance index value of the performance indicator to obtain
Analyze result.It is the sub-process schematic diagram of step S105 referring to Fig. 2.As shown, step S105 includes rapid S201~S203.
S201 calculates the corresponding mean value of each performance indicator and standard deviation according to the historical performance index value.
Specifically, as described above, obtaining the history of 11 points of each performance indicators of every morning between 2017 2/3~3/3
Performance index value.It follows that during this period, each performance indicator includes 29 historical performance index values.Such as according to CPU
The mean value and standard deviation that CPU uses the time is calculated using 29 historical performance index values of time, and CPU is used into the time
Corresponding mean value is labeled as μ 1, is σ 1 by its corresponding label standard deviation;According to the 29 of the I/O waiting time historical performance indexs
The mean value and standard deviation of I/O waiting time is calculated in value, and I/O waiting time corresponding mean value is labeled as μ 2, its is right
The label standard deviation answered is σ 2;The Lock waiting time is calculated according to the 29 of the Lock waiting time historical performance index values
Mean value and standard deviation, and Lock waiting time corresponding mean value is labeled as μ 3, it is σ 3 by its corresponding label standard deviation.
S202 determines the reference of each current performance index value according to the mean value, standard deviation and Six Sigma model
Threshold range.
Specifically, whether Six Sigma model is to use six times of standard deviation normal as each current performance index value of judgement
Reference threshold range.It follows that CPU using the time current performance index value X1 reference threshold range be μ 1-6 σ 1,
μ1+6σ1};The reference threshold range of the current performance index value X2 of I/O waiting time is { μ 2-6 σ 2, μ 2+6 σ 2 };Lock is waited
The reference threshold range of the current performance index value X3 of time is { μ 3-6 σ 3, μ 3+6 σ 3 }.
S203 judges the current performance index value of the performance indicator to be analyzed according to identified reference threshold range
As a result.
Specifically, the reference threshold range of the current performance index value of each performance indicator according to obtained in step S202
Come determine current performance index value whether within the scope of reference threshold with obtain analysis result.It further, is step referring to Fig. 3
The sub-process schematic diagram of rapid S203.As shown, S203 includes rapid S301~S303.
Whether S301 judges the current performance index value of the performance indicator within the scope of the reference threshold.
Specifically, judge CPU using the current performance index value X1 of time whether in reference threshold range { μ 1-6 σ 1, μ 1+
6 σ 1 } in, judge the current performance index value X2 of I/O waiting time whether in reference threshold range f μ 2-6 σ 2, μ 2+6 σ 2 } in,
And judge the current performance index value X3 of Lock waiting time whether in reference threshold range { μ 3-6 σ 3, μ 3+6 σ 3 }.
S302, if the current performance index value within the scope of the reference threshold, determines the current performance index value
Normally.
S303, if the current performance index value not within the scope of the reference threshold, determines the current performance indicator
Value is abnormal.
Specifically, if CPU uses the current performance index value X1 of time at reference threshold range { μ 1-6 σ 1, μ 1+6 σ 1 }
Interior, i.e. 1≤X1 of μ 1-6 σ≤μ 1+6 σ 1 then determines that the current performance index value is normal, otherwise determines performance index value exception;
If the current performance index value X2 of I/O waiting time is interior in reference threshold range { μ 2-6 σ 2, μ 2+6 σ 2 }, i.e. 2≤X2 of μ 2-6 σ≤
μ 2+6 σ 2 then determines that the current performance index value is normal, otherwise determines performance index value exception;If the Lock waiting time works as
Preceding performance index value X3 then determines that the current performance index value is normal, otherwise in reference threshold range { μ 3-6 σ 3, μ 3+6 σ 3 }
Determine performance index value exception.
The incidence relation between performance indicator and database dimension that the embodiment of the present invention passes through creation database, and then adopt
Collect each performance indicator in the corresponding sub- performance index value in different dimensions place, then by same performance index at different dimensions
Sub- performance index value it is cumulative to obtain the current performance index value of the performance indicator, and obtain corresponding to each performance indicator
Multiple historical performance index values analyze the corresponding current performance of each performance indicator according to historical performance index value and preset algorithm
Index value is to obtain analysis result.The concentration that the embodiment of the present invention can carry out various dimensions to the performance indicator of database is analyzed,
To carry out trend analysis and abnormal judgement.
Referring to Fig. 4, be another embodiment of the present invention provides database performance index monitoring method schematic flow diagram.
As shown, this method includes S401~S410.
S401 creates the incidence relation between the performance indicator of database and database dimension.
S402 acquires each performance indicator in the corresponding sub- performance index value in different dimensions place.
S403 adds up sub- performance index value of the same performance index at different dimensions to obtain working as the performance indicator
Preceding performance index value.
S404, obtains multiple historical performance index values corresponding to each performance indicator, the historical performance index value with
The current performance index value is corresponding.
Specifically, step S401~S404 is identical as step S101~S104, and details are not described herein again.
S405 calculates the corresponding mean value of each performance indicator and standard deviation according to the historical performance index value.
S406 determines the reference of each current performance index value according to the mean value, standard deviation and Six Sigma model
Threshold range.
S407 judges the current performance index value of the performance indicator to be analyzed according to identified reference threshold range
As a result.
Specifically, step S405~S407 is identical as step S201~S203, and details are not described herein again.
S408 draws the corresponding monitoring figure of each performance indicator according to the mean value, standard deviation and Six Sigma model.
S409 shows the monitoring figure of each performance indicator.
S410 marks the described current performance index value on the monitoring figure.
It specifically, is that offer CPU of the embodiment of the present invention uses time, I/O waiting time and Lock etc. referring to Fig. 5 to Fig. 7
Monitoring figure to the time.As shown, CPU using the current performance index value X1 of time obey mathematic expectaion be μ 1,
Standard deviation is (σ 1)2Normal distribution, reference threshold range be { μ 1-6 σ 1, μ 1+6 σ 1 };The current performance of I/O waiting time
Index value X2 one mathematic expectaion of obedience is μ 2, standard deviation is (σ 2)2Normal distribution, reference threshold range be μ 2-6 σ 2,
μ2+6σ2};Current performance index value X3 one mathematic expectaion of obedience of Lock waiting time is μ 3, standard deviation is (σ 3)2Just
State distribution, reference threshold range are { μ 3-6 σ 3, μ 3+6 σ 3 }.Further, the corresponding label of current performance index value is existed
On corresponding monitoring figure.As shown in figure 5, CPU occurs the reference in monitoring figure using the current performance index value X1 of time
Threshold range is in { μ 1-6 σ 1, μ 1+6 σ 1 }, it can thus be appreciated that the CPU is normal using the current performance index value X1 of time.Such as Fig. 6
Shown, it is { μ 2-6 σ 2, μ 2+6 σ that the reference threshold range in monitoring figure, which occurs, in the current performance index value X2 of I/O waiting time
2 } outside, and positioned at the right side of μ 2+6 σ 2, it can thus be appreciated that the current performance index value X2 of the I/O waiting time is abnormal, and this is current
Performance index value is greater than the upper limit of reference threshold range.As shown in fig. 7, the current performance index value X3 of Lock waiting time occurs
Monitoring the reference threshold range in figure is f μ 3-6 σ 3, μ 3+6 σ 3 } in, and it is located at the left side of μ 3-6 σ 3, it can thus be appreciated that Lock etc.
Current performance index value X3 to the time is abnormal, and the current performance index value is less than the lower limit of reference threshold range.
The incidence relation between performance indicator and database dimension that the embodiment of the present invention passes through creation database, and then adopt
Collect each performance indicator in the corresponding sub- performance index value in different dimensions place, then by same performance index at different dimensions
Sub- performance index value it is cumulative to obtain the current performance index value of the performance indicator, and obtain corresponding to each performance indicator
Multiple historical performance index values analyze the corresponding current performance of each performance indicator according to historical performance index value and preset algorithm
Index value is to obtain analysis result.The embodiment of the present invention, which passes through, to be shown the corresponding monitoring figure of the performance indicator is corresponding
And the corresponding label of current performance index is realized to the collection that various dimensions are carried out to the performance indicator of database on monitoring figure
Middle analysis, intuitively to carry out trend analysis and abnormal judgement.
It is a kind of schematic block diagram of the monitoring device of database performance index provided in an embodiment of the present invention referring to Fig. 8.
Device 50 in the present embodiment as shown in the figure include creating unit 51, acquisition unit 52, summing elements 53, acquiring unit 54,
And analytical unit 55.
Creating unit 51, for creating the incidence relation between the performance indicator of database and database dimension.
Acquisition unit 52, for acquiring each performance indicator in the corresponding sub- performance index value in different dimensions place.
Summing elements 53, for adding up sub- performance index value of the same performance index at different dimensions to obtain the property
The current performance index value of energy index.
Acquiring unit 54, for obtaining multiple historical performance index values, the history corresponding to each performance indicator
Energy index value is corresponding with the current performance index value.
Analytical unit 55, for analyzing the property according to the historical performance index value and preset algorithm of each performance indicator
The current performance index value of energy index is to obtain analysis result.
It further, is the structural schematic diagram of analytical unit 55 in Fig. 8 referring to Fig. 9.As shown, analytical unit 55 wraps
Include computing unit 551, determination unit 552 and judging unit 553.
Summing elements 551, for calculating each performance indicator in different dimensions information according to the historical performance index value
The corresponding mean value in place and standard deviation.
Determination unit 552, for determining that each current performance refers to according to the mean value, standard deviation and Six Sigma model
The reference threshold range of scale value.
Judging unit 553, for judging the current performance index of the performance indicator according to identified reference threshold range
Value is to obtain analysis result.
Further, referring to Fig.1 0, it is the structural schematic diagram of judging unit 553 in Fig. 9.As shown, judging unit 553
Including verification unit 5531 and judging unit 5532.
Unit 5531 is checked, for judging the current performance index value of the performance indicator whether in the reference threshold range
It is interior.
Judging unit 5532, if judgement is deserved for the current performance index value within the scope of the reference threshold
Preceding performance index value is normal;If the current performance index value determines the current performance not within the scope of the reference threshold
Index value is abnormal.
The incidence relation between performance indicator and database dimension that the embodiment of the present invention passes through creation database, and then adopt
Collect each performance indicator in the corresponding sub- performance index value in different dimensions place, then by same performance index at different dimensions
Sub- performance index value it is cumulative to obtain the current performance index value of the performance indicator, and obtain corresponding to each performance indicator
Multiple historical performance index values analyze the corresponding current performance of each performance indicator according to historical performance index value and preset algorithm
Index value is to obtain analysis result.The concentration that the embodiment of the present invention can carry out various dimensions to the performance indicator of database is analyzed,
To carry out trend analysis and abnormal judgement.
Referring to Fig.1 1, be another embodiment of the present invention provides database performance index monitoring device schematic frame
Figure.Device 60 in the present embodiment as shown in the figure includes creating unit 61, acquisition unit 62, summing elements 63, acquiring unit
64, computing unit 65, determination unit 66, verification unit 67, judging unit 68, drawing unit 69, display unit 70 and label are single
Member 71.
Creating unit 61, for creating the incidence relation between the performance indicator of database and database dimension
Acquisition unit 62, for acquiring each performance indicator in the corresponding sub- performance index value in different dimensions place.
Summing elements 63, for adding up sub- performance index value of the same performance index at different dimensions to obtain the property
The current performance index value of energy index.
Acquiring unit 64, for obtaining multiple historical performance index values, the history corresponding to each performance indicator
Energy index value is corresponding with the current performance index value.
Computing unit 65, for calculating each performance indicator at different dimensions information according to the historical performance index value
Corresponding mean value and standard deviation.
Determination unit 66, for determining that each current performance refers to according to the mean value, standard deviation and Six Sigma model
The reference threshold range of scale value.
Unit 67 is checked, for judging the current performance index value of the performance indicator whether in the reference threshold range
It is interior.
Judging unit 68, if determining that this is current for the current performance index value within the scope of the reference threshold
Performance index value is normal;If the current performance index value not within the scope of the reference threshold, determines that the current performance refers to
Scale value is abnormal.
Drawing unit 69, for drawing the monitoring of each performance indicator according to the mean value, standard deviation and Six Sigma model
Figure.
Display unit 70, for showing the monitoring figure of each performance indicator.
Marking unit 71, for marking the described current performance index value on the monitoring figure.
The incidence relation between performance indicator and database dimension that the embodiment of the present invention passes through creation database, and then adopt
Collect each performance indicator in the corresponding sub- performance index value in different dimensions place, then by same performance index at different dimensions
Sub- performance index value it is cumulative to obtain the current performance index value of the performance indicator, and obtain corresponding to each performance indicator
Multiple historical performance index values analyze the corresponding current performance of each performance indicator according to historical performance index value and preset algorithm
Index value is to obtain analysis result.The embodiment of the present invention, which passes through, to be shown the corresponding monitoring figure of the performance indicator is corresponding
And the corresponding label of current performance index is realized to the collection that various dimensions are carried out to the performance indicator of database on monitoring figure
Middle analysis, intuitively to carry out trend analysis and abnormal judgement.
If unit described in the embodiment of the present invention is realized in the form of software function module and as independent product
When selling or using, it also can store in a computer readable storage medium.Based on this understanding, the present invention is implemented
Substantially the part that contributes to existing technology can be embodied in the form of software products the technical solution of example in other words,
The computer software product is stored in a storage medium, including some instructions are used so that computer equipment (can be with
It is personal computer, server or network equipment etc.) execute all or part of each embodiment the method for the present invention.
And the storage medium includes USB flash disk, mobile hard disk, read-only memory (ROM, Read Only Memory), random access memory
(RAM, Random Access Memory), the various media that can store program code such as magnetic or disk.In this way, this hair
Bright embodiment is not limited to any specific hardware and software and combines.
Correspondingly, the embodiment of the present invention also describes a kind of computer readable storage medium, the storage medium have one or
More than one program of person, this or more than one program can be executed by one or more than one processor with realize with
Lower step: the incidence relation between the performance indicator of database and database dimension is created;Each performance indicator is acquired in difference
The corresponding sub- performance index value in dimension place;Sub- performance index value of the same performance index at different dimensions is added up to obtain
The current performance index value of the performance indicator;Multiple historical performance index values corresponding to each performance indicator are obtained, it is described to go through
History performance index value is corresponding with the current performance index value;According to the historical performance index value of each performance indicator and
Preset algorithm analyzes the current performance index value of the performance indicator to obtain analysis result.
Preferably, the historical performance index value and preset algorithm according to each performance indicator is analyzed the performance and is referred to
Target current performance index value is to obtain analysis result the following steps are included: calculating each property according to the historical performance index value
It can the corresponding mean value of index and standard deviation;Each current performance is determined according to the mean value, standard deviation and Six Sigma model
The reference threshold range of index value;According to identified reference threshold range judge the current performance index value of the performance indicator with
Obtain analysis result.
Preferably, the reference threshold range according to determined by judges the current performance index value of the performance indicator to obtain
To analysis result the following steps are included: judging the current performance index value of the performance indicator whether in the reference threshold range
It is interior;If the current performance index value within the scope of the reference threshold, determines that the current performance index value is normal;If described
Current performance index value then determines that the current performance index value is abnormal not within the scope of the reference threshold.
Preferably, the one or more programs can also be executed by the processor of the one or more
The corresponding monitoring figure of each performance indicator is drawn according to the mean value, standard deviation and Six Sigma model to perform the steps of;
Show the monitoring figure of each performance indicator;The described current performance index value is marked on the monitoring figure.
Preferably, the performance indicator includes that CPU uses time, I/O waiting time and Lock waiting time, the dimension
Degree includes SQL, EVENT, OBJECT and USER.
Referring to Fig.1 2, it is a kind of schematic frame of the monitoring device of database performance index provided in an embodiment of the present invention
Figure.As shown, the equipment 80 includes one or several processors 81, memory 82, one or several input dresses
Set 83, one or several output devices 84.Above-mentioned processor 81, input unit 83, output device 84 and memory 82
It is connected by bus 85.
Input unit 83 for user for inputting operation instruction.In the specific implementation, the input unit 83 of the embodiment of the present invention
It may include keyboard, mouse, photoelectricity input unit, acoustic input dephonoprojectoscope, touch input unit etc..
Output device 84 is used to show the monitoring figure of each performance indicator.In the specific implementation, the embodiment of the present invention is defeated
Device 84 may include display, display screen, touch screen etc. out.
Memory 82 is used to store the computer program and data for so that monitoring device is realized specific function and operation, for example,
For storing so that monitoring device is realized database performance Indexs measure program and data;In the concrete realization, the present invention is implemented
The memory 82 of example can be system storage, for example, volatile (such as RAM), non-volatile (such as ROM, flash memory
Deng), or both combination.In the specific implementation, the memory 82 of the embodiment of the present invention can also be that the outside except system is deposited
Reservoir, for example, disk, CD, tape etc..
Processor 81 is for executing the computer program stored in memory 82 and data to perform the following operations:
Create the incidence relation between the performance indicator and database dimension of database;Each performance indicator is acquired in difference
The corresponding sub- performance index value in dimension place;Sub- performance index value of the same performance index at different dimensions is added up to obtain
The current performance index value of the performance indicator;Multiple historical performance index values corresponding to each performance indicator are obtained, it is described to go through
History performance index value is corresponding with the current performance index value;According to the historical performance index value of each performance indicator and
Preset algorithm analyzes the current performance index value of the performance indicator to obtain analysis result.
Further, described that the performance is analyzed according to the historical performance index value and preset algorithm of each performance indicator
The current performance index value of index includes: to calculate each performance indicator according to the historical performance index value to obtain analysis result
Corresponding mean value and standard deviation;Each current performance index value is determined according to the mean value, standard deviation and Six Sigma model
Reference threshold range;Judge the current performance index value of the performance indicator to be divided according to identified reference threshold range
Analyse result.
Further, the reference threshold range according to determined by judge the current performance index value of the performance indicator with
Whether obtain analysis result includes: to judge the current performance index value of the performance indicator within the scope of the reference threshold;If institute
Current performance index value is stated within the scope of the reference threshold, then determines that the current performance index value is normal;If described currency
Energy index value then determines that the current performance index value is abnormal not within the scope of the reference threshold.
Further, the processor 81 also executes following operation: being drawn according to the mean value, standard deviation and Six Sigma model
Make the corresponding monitoring figure of each performance indicator;Show the monitoring figure of each performance indicator;It is marked on the monitoring figure
The described current performance index value.
Further, the performance indicator includes CPU using time, I/O waiting time and Lock waiting time, described
Dimension includes SQL, EVENT, OBJECT and USER.
It is apparent to those skilled in the art that for convenience of description and succinctly, the end of foregoing description
The specific work process at end and unit, can refer to corresponding processes in the foregoing method embodiment, details are not described herein.
In several embodiments provided herein, it should be understood that disclosed terminal and method can pass through it
Its mode is realized.For example, appliance arrangement embodiment described above is only schematical, for example, the unit is drawn
Point, only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can
To combine or be desirably integrated into another system, or some features can be ignored or not executed.In addition, shown or discussed
Mutual coupling, direct-coupling or communication connection can be through some interfaces, the indirect coupling of appliance arrangement or unit
It closes or communicates to connect, be also possible to electricity, mechanical or other forms connections.
Those of ordinary skill in the art will appreciate that realizing that all or part of the steps of the method for above-described embodiment can lead to
Hardware is crossed to complete, relevant hardware can also be instructed to complete by program, the program can store in a kind of calculating
In machine readable storage medium storing program for executing, storage medium mentioned above can be read-only memory, disk or CD etc..Also, the present invention
Step in above-described embodiment method can be sequentially adjusted, merged and deleted according to actual needs.
Unit in the terminal of that embodiment of the invention can be combined, divided and deleted according to actual needs.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.Some or all of unit therein can be selected to realize the embodiment of the present invention according to the actual needs
Purpose.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, is also possible to two or more units and is integrated in one unit.It is above-mentioned integrated
Unit both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, technical solution of the present invention is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, terminal or the network equipment etc.) executes the whole of each embodiment the method for the present invention
Or part steps.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only
Memory), random access memory (RAM, Random Access Memory), magnetic or disk etc. are various can store journey
The medium of sequence code.
The above are the preferred embodiments of invention, rather than do limitation in any form to invention.Those skilled in the art
Various equivalent changes and improvement, all equivalent changes done within the scope of the claims can be imposed on the basis of the above embodiments
Change or modify, should all fall within the scope of invention.
Claims (8)
1. a kind of monitoring method of database performance index characterized by comprising
Create the incidence relation between the performance indicator and database dimension of database;
Each performance indicator is acquired in the corresponding sub- performance index value in different dimensions place;
Sub- performance index value of the same performance index at different dimensions is added up to obtain the current performance of the performance indicator and refer to
Scale value;
Obtain multiple historical performance index values corresponding to each performance indicator, the historical performance index value with it is described currency
Energy index value is corresponding;
Referred to according to the current performance that the historical performance index value and preset algorithm of each performance indicator analyze the performance indicator
Scale value is to obtain analysis result;
Wherein, described that working as the performance indicator is analyzed according to the historical performance index value and preset algorithm of each performance indicator
Preceding performance index value with obtain analysis result include:
The corresponding mean value of each performance indicator and standard deviation are calculated according to the historical performance index value;
The reference threshold range of each current performance index value is determined according to the mean value, standard deviation and Six Sigma model;
The current performance index value of the performance indicator is judged according to identified reference threshold range to obtain analysis result.
2. the method as described in claim 1, which is characterized in that the reference threshold range according to determined by judges the performance
The current performance index value of index with obtain analysis result include:
Judge the current performance index value of the performance indicator whether within the scope of the reference threshold;
If the current performance index value within the scope of the reference threshold, determines that the current performance index value is normal;
If the current performance index value not within the scope of the reference threshold, determines that the current performance index value is abnormal.
3. the method as described in claim 1, which is characterized in that the method also includes:
The corresponding monitoring figure of each performance indicator is drawn according to the mean value, standard deviation and Six Sigma model;
Show the monitoring figure of each performance indicator;
The described current performance index value is marked on the monitoring figure.
4. the method as described in claim 1, which is characterized in that when the performance indicator includes that CPU is waited using time, I/O
Between and Lock waiting time, the dimension include SQL, EVENT, OBJECT and USER.
5. a kind of monitoring device of database performance index, which is characterized in that
Creating unit, for creating the incidence relation between the performance indicator of database and database dimension;
Acquisition unit, for acquiring each performance indicator in the corresponding sub- performance index value in different dimensions place;
Summing elements, for adding up sub- performance index value of the same performance index at different dimensions to obtain the performance indicator
Current performance index value;
Acquiring unit, for obtaining multiple historical performance index values corresponding to each performance indicator, the historical performance index
It is worth corresponding with the current performance index value;
Analytical unit, for analyzing the performance indicator according to the historical performance index value and preset algorithm of each performance indicator
Current performance index value with obtain analysis result;
The analytical unit includes:
Computing unit, it is corresponding in different dimensions place for calculating each performance indicator according to the historical performance index value
Value and standard deviation;
Determination unit, for determining each current performance index value according to the mean value, standard deviation and Six Sigma model
Reference threshold range;
Judging unit, for being judged the current performance index value of the performance indicator to obtain according to identified reference threshold range
Analyze result.
6. device as claimed in claim 5, which is characterized in that the judging unit includes:
Unit is checked, for judging the current performance index value of the performance indicator whether within the scope of the reference threshold;
Judging unit, if determining that the current performance refers within the scope of the reference threshold for the current performance index value
Scale value is normal;If the current performance index value in reference to the threshold range, does not determine that the current performance index value is different
Often.
7. a kind of computer readable storage medium, which is characterized in that the storage medium has one or more than one program, should
One or more than one program can be executed by one or more than one processor to perform the steps of creation database
Performance indicator and database dimension between incidence relation;Each performance indicator is acquired in the corresponding sub- property in different dimensions place
It can index value;Sub- performance index value of the same performance index at different dimensions is added up to obtain the currency of the performance indicator
It can index value;Obtain multiple historical performance index values corresponding to each performance indicator, the historical performance index value with it is described
Current performance index value is corresponding;The performance is analyzed according to the historical performance index value and preset algorithm of each performance indicator
The current performance index value of index is to obtain analysis result;Wherein, described to be referred to according to the historical performance of each performance indicator
It includes: according to the history that scale value and preset algorithm, which analyze the current performance index value of the performance indicator to obtain analysis result,
It can the corresponding mean value of each performance indicator of index value calculating and standard deviation;It is true according to the mean value, standard deviation and Six Sigma model
The reference threshold range of fixed each current performance index value;The performance indicator is judged according to identified reference threshold range
Current performance index value with obtain analysis result.
8. a kind of monitoring device of database performance index, which is characterized in that the equipment includes: memory and processor;
The memory is for storing at least one computer program;
The processor reads the computer program in the memory to execute following operation:
Create the incidence relation between the performance indicator and database dimension of database;
Each performance indicator is acquired in the corresponding sub- performance index value in different dimensions place;
Sub- performance index value of the same performance index at different dimensions is added up to obtain the current performance of the performance indicator and refer to
Scale value;
Obtain multiple historical performance index values corresponding to each performance indicator, the historical performance index value with it is described currency
Energy index value is corresponding;
Referred to according to the current performance that the historical performance index value and preset algorithm of each performance indicator analyze the performance indicator
Scale value is to obtain analysis result;
Wherein, described that working as the performance indicator is analyzed according to the historical performance index value and preset algorithm of each performance indicator
Preceding performance index value with obtain analysis result include:
The corresponding mean value of each performance indicator and standard deviation are calculated according to the historical performance index value;
The reference threshold range of each current performance index value is determined according to the mean value, standard deviation and Six Sigma model;
The current performance index value of the performance indicator is judged according to identified reference threshold range to obtain analysis result.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710454882.2A CN107908533B (en) | 2017-06-15 | 2017-06-15 | A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index |
PCT/CN2018/083703 WO2018228049A1 (en) | 2017-06-15 | 2018-04-19 | Database performance index monitoring method, apparatus and device, and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710454882.2A CN107908533B (en) | 2017-06-15 | 2017-06-15 | A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107908533A CN107908533A (en) | 2018-04-13 |
CN107908533B true CN107908533B (en) | 2019-11-12 |
Family
ID=61840998
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710454882.2A Active CN107908533B (en) | 2017-06-15 | 2017-06-15 | A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN107908533B (en) |
WO (1) | WO2018228049A1 (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021184554A1 (en) * | 2020-03-18 | 2021-09-23 | 平安科技(深圳)有限公司 | Database exception monitoring method and device, computer device, and storage medium |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107908533B (en) * | 2017-06-15 | 2019-11-12 | 平安科技(深圳)有限公司 | A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index |
CN109446017A (en) * | 2018-09-03 | 2019-03-08 | 平安科技(深圳)有限公司 | A kind of alarm algorithm generation method, monitoring system and terminal device |
CN109684162B (en) * | 2018-11-09 | 2022-05-27 | 平安科技(深圳)有限公司 | Equipment state prediction method, system, terminal and computer readable storage medium |
CN109558295B (en) * | 2018-11-15 | 2022-05-24 | 新华三信息安全技术有限公司 | Performance index abnormality detection method and device |
CN110851676B (en) * | 2019-10-08 | 2022-08-09 | 支付宝(杭州)信息技术有限公司 | Index data processing method and device and electronic equipment |
CN112269723B (en) * | 2020-10-16 | 2023-01-10 | 苏州浪潮智能科技有限公司 | Performance analysis method and device of storage equipment and readable storage medium |
CN112163841A (en) * | 2020-11-19 | 2021-01-01 | 树根互联技术有限公司 | Asset equipment index establishing method and device and electronic equipment |
Family Cites Families (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2015141218A1 (en) * | 2014-03-18 | 2015-09-24 | 日本電気株式会社 | Information processing device, analysis method, and program recording medium |
CN103886068B (en) * | 2014-03-20 | 2018-04-03 | 北京国双科技有限公司 | Data processing method and device for Internet user's behavioural analysis |
CN104123477A (en) * | 2014-08-15 | 2014-10-29 | 上海博路信息技术有限公司 | Group-oriented leasing analysis method based on life data |
US11556876B2 (en) * | 2015-01-05 | 2023-01-17 | International Business Machines Corporation | Detecting business anomalies utilizing information velocity and other parameters using statistical analysis |
CN104715027B (en) * | 2015-03-04 | 2018-03-30 | 北京京东尚科信息技术有限公司 | A kind of distributed data unusual fluctuation judges localization method and system |
CN104735710B (en) * | 2015-03-18 | 2018-09-04 | 大连理工大学 | A kind of mobile network property early warning pre-judging method based on trend extropolation cluster |
CN105261240B (en) * | 2015-09-30 | 2018-01-30 | 中国民用航空总局第二研究所 | A kind of sector runnability method for comprehensive detection and system based on cluster analysis |
CN107908533B (en) * | 2017-06-15 | 2019-11-12 | 平安科技(深圳)有限公司 | A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index |
-
2017
- 2017-06-15 CN CN201710454882.2A patent/CN107908533B/en active Active
-
2018
- 2018-04-19 WO PCT/CN2018/083703 patent/WO2018228049A1/en active Application Filing
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021184554A1 (en) * | 2020-03-18 | 2021-09-23 | 平安科技(深圳)有限公司 | Database exception monitoring method and device, computer device, and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN107908533A (en) | 2018-04-13 |
WO2018228049A1 (en) | 2018-12-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107908533B (en) | A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index | |
CN108022043B (en) | Abnormal electricity consumption behavior identification method and device and central server | |
EP1416385A2 (en) | Parallel efficiency calculation method and apparatus | |
CN107086944A (en) | A kind of method for detecting abnormality and device | |
US8903757B2 (en) | Proactive information technology infrastructure management | |
CN109947812A (en) | Consecutive miss value fill method, data analysis set-up, terminal and storage medium | |
CN111314173B (en) | Monitoring information abnormity positioning method and device, computer equipment and storage medium | |
CN105721187A (en) | Service fault diagnosis method and apparatus | |
CN109670690A (en) | Data information center monitoring and early warning method, system and equipment | |
CN105654229A (en) | Power grid automation system and equipment running state risk assessment algorithm | |
CN111160404B (en) | Analysis method and device for reasonable value of line loss marker post of power distribution network | |
CN105894329A (en) | Data analysis method and device | |
CN108932217A (en) | The method and device of energy consumption statistic | |
CN109445768B (en) | Database script generation method and device, computer equipment and storage medium | |
CN109412839A (en) | A kind of recognition methods, device, equipment and the storage medium of exception account | |
CN113807004A (en) | Tool life prediction method, device and system based on data mining | |
Litoriya et al. | Incorporating Cost driver substitution to improve the effort using Agile COCOMO II | |
CN109559206A (en) | A kind of regional enterprises Credit Evaluation System method, apparatus and terminal device | |
CN106528774A (en) | Method and apparatus for predicting distribution network project management trend | |
US11244235B2 (en) | Data analysis device and analysis method | |
CN114757482A (en) | Method, system, device and medium for analyzing electric quantity use trend of user group | |
CN114416561A (en) | Pressure test configuration method and device | |
CN109885600B (en) | Forest vegetation growth rate analysis method and system | |
CN113656243A (en) | Service index monitoring method, device, equipment and storage medium | |
CN112801441A (en) | Analysis system and analysis method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |