CN101013442A - Non-proxy unified method for monitoring performance of data base - Google Patents
Non-proxy unified method for monitoring performance of data base Download PDFInfo
- Publication number
- CN101013442A CN101013442A CN 200710067200 CN200710067200A CN101013442A CN 101013442 A CN101013442 A CN 101013442A CN 200710067200 CN200710067200 CN 200710067200 CN 200710067200 A CN200710067200 A CN 200710067200A CN 101013442 A CN101013442 A CN 101013442A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- monitoring
- performance
- monitored
- 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.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a unified free agent database performance monitoring method. Use the configuration file to describe various contents needed to be monitored, including the data information, data acquisition methods. The monitoring program optimizes the monitoring rules after reading configuration files to reduce number of query sentences and act as the base of the monitoring data reader module extracts performance data from database. Then, the monitoring program extracts performance data from the monitored database and writes to the performance database periodically according to the configuration. The invention can realize the database monitoring without installing agent in the monitored terminal. It reduces the installation requirements of database monitoring and makes the deployment easier while it can realize various databases monitoring by only providing different configuration files, with good flexibility and scalability.
Description
Technical field
The present invention relates to database technical field, relate in particular to a kind of non-proxy unified method for monitoring of database performance.
Background technology
Along with the continuous development of computer technology and mechanics of communication, each large enterprises has all accelerated the paces of informatization, and is also progressively perfect as the information network platform construction of infrastructure wherein.Rely on this basic platform affiliate, supplier, client and employee organically can be combined, for senior enterprise leader decision-making, department information interchange, international communication etc. provide valid approach.But along with the complicacy of application demand increases, the continuous expansion of network size causes network failure rates raising, manageability to descend.The continuous appearance of increasing, the system vulnerability of virus overflowing in addition, assault, make under traditional network management pattern, a large amount of daily network failures needs artificial location, manually gets rid of, inefficiency not only, whole production business activities to enterprise have simultaneously also produced tremendous influence, and have hindered the paces of IT application in enterprises development to a certain extent.
Therefore, the construction and the management of company information network platform are reached a new high, realizing searching fast, locate fast, getting rid of fast of network failure in daily servicing, break away from the passive network managing mode of " incoming call response type ", is the key that promotes IT application in enterprise.
The monitoring of database performance is an important content of enterprise network management, the centralization of fulfillment database performance, Intellectualized monitoring for the normal operation of enterprise, IT application in enterprises normally carry out all significant.
Summary of the invention
The non-proxy unified method for monitoring that the purpose of this invention is to provide a kind of database performance.
The non-proxy unified method for monitoring of database performance: use configuration file to describe the various databases that need monitoring, and use unified watchdog routine, the monitor data item according to configuration file is described connects the reading database performance data by network; After obtaining performance data, it with the threshold of predesignating, is triggered the alarm action if desired; Simultaneously in the data write performance database.
Described configuration file: comprised the various information of monitor database object data item in the configuration file, comprised the sign of information, data item of monitored database and classification, the type of data item, the acquisition methods of data item occurrence; Data item is divided into two classes, is respectively monitored variable and smooth table; Configuration file adopts the common ini file form of Windows operating system.
Watchdog routine: after watchdog routine reads configuration file, the SQL statement that reads the monitor data item is optimized, merges the identical statement of main part, to reduce influence to monitored database; Watchdog routine is compared data after obtaining monitor data with pre-set threshold, the data item that exceeds threshold value alarmed, and all data item write performance databases.
Performance database: the table in the performance database is divided into two classes, for smooth table, has structure with it identical but increased the tables of data of time and monitored Database Identification field; For monitored variable, three tables are arranged in the performance database, the monitor data of the description of classification, variable of variable and threshold value, variable is described respectively.
Advantage of the present invention is: 1) need not can realize performance monitoring in monitored database side installation agent, lower deployment cost is low; 2) use same program code, only need write different configuration files and can realize monitoring to disparate databases making it have good retractility and extensibility; 3) performance monitoring of support variable type and data phenotype can be supported all common type of database.
Description of drawings
Fig. 1 is the treatment scheme of data-base performance monitoring configuration data;
Fig. 2 is the structural drawing of main modular of the present invention;
Fig. 3 is the process flow diagram of data-base performance monitoring among the present invention;
Embodiment
The concrete steps of the non-proxy unified method for monitoring of database performance are as follows:
1) the performance of database data is summed up as monitored variable and monitoring form.
The support that existing database is all built-in bar none extracts performance own, this also becomes the basis that the present invention uses unified method that database performance is monitored.But the method for expressing of performance data is different in the different databases: the database that has is kept at the performance database of itself in system's table, and these system's tables can be operated (as Oracle and Microsoft SQL Server) as other tables; The other database then performance data maintenance in data structure itself, can extract by fill order, and the data of extracting seem also similarly to be the same (as MySQL and the DB2) that reads from tables of data, and we claim these tables to be " Virtual table ".No matter be which kind of situation, can connect by TCP and send certain order or carry out certain SQL statement and extract performance data.
No matter be the real data table, still " Virtual table " according to the organizational form of its content, can be divided into following two kinds: the content of (1) table is the performance data of a certain particular aspects of database, and each row of table all have the certain sense of predefined.(2) Biao content is a series of variablees, and has row such as " variable name " or " variable numbering ", " variate-value ", " types of variables " in the table.After taking out content, we can inquire about the meaning of knowing the variable representative according to variable name or through the variable numbering.
Be the example (oracle database) of monitoring form below:
SQL>SELECT?CREATED,LOG_MODE?FROM?V$DATABASE;
CREATED LOG_MODE
---------------
The 14-10 month-06 NOARCHIVELOG
SQL> select?TABLESPACE_NAME, BLOCK_SIZE, STATUS, LOGGING from
DBA_TABLESPACES;
TABLESPACE_NAME BLOCK_SIZE?STATUS LOGGING
--------------------------
SYSTEM 8192?ONLINE LOGGING
UNDOTBS1 8192?ONLINE LOGGING
TEMP 8192?ONLINE NOLOGGING
CWMLITE 8192?ONLINE LOGGING
DRSYS 8192?ONLINE LOGGING
EXAMPLE 8192?ONLINE LOGGING
INDX 8192?ONLINE LOGGING
Above twice inquiry from two system's tables, obtained the information of database and table space respectively, our also meaning of this column data representative as can be seen on the name of row.Each line data in the table is represented a significant record, is relation arranged side by side between the record.
Be the example (MySQL database and SQL Server database) of monitored variable: show variables like " %size% " below;
Variable_name | ?Value |
?bulk_insert_buffer_size | ?32768 |
?delayed_queue_size | ?8388608 |
?innodb_additional_mem_pool_size | ?1000 |
?innodb_buffer_pool_size | ?2097152 |
?innodb_log_buffer_size | ?8388608 |
select*from?master.dbo.sysperfinfo;
object_name counter_name instance_name?cntr_value cntr_type
SQLServer:Buffer?ManagerBuffer?cache?hit?ratio 1273 537003008
SQLServer:Buffer?ManagerBuffer?cachehuit?ratio?base?1296 1073939459
SQLServer:Buffer?ManagerPage?lookups/sec 7296 272696320
SQLServer:Buffer?ManagerFree?list?stalls/sec 0 272696320
SQLServer:Buffer?ManagerFree?pages 133 65536
In the above example, obtained many data with SQL statement or order equally, but before checking concrete record, we can not know the meaning of record representative.Record is the data of " variable name-variate-value " type, does not have relation between each bar record.
2) with configuration file monitored variable and monitoring form are described.
The object that will monitor clearly is divided into after two classes, can describes these monitored object, and be used for watchdog routine database is monitored with configuration file.Configuration file adopts the ini file form of windows platform, that is:
A. use the plain text coding, can use the arbitrary text editing machine to check, revise;
B. configuration file is made of some joints (Section), and each joint is divided into section name and joint body two parts, and section name is the character string that bracket (" [" and "] ") fences up, as " [main] ".The joint body is expressed as the item description of equation for several, and the equal sign left side is an entry name, and the right is an item value.As " VarNum=5 ".
C. the behavior comment line that begins with branch can be left in the basket in parsing.
To be described configuration data with the ini file form, must comprise a main joint in the configuration file, with the content of describe, in general terms configuration file.Following items is arranged in the main joint:
The number of VariableNum---variable description.If 5 variablees are arranged, VariableNum=5, configuration file have 5 joints to describe 5 variablees respectively in addition, and section name is respectively Var1 ~ Var5.
TableNum---the number of monitoring form.If 3 monitoring forms are arranged, TableNum=3, configuration file have 3 joints to describe 3 tables respectively in addition, and section name is respectively Table1 ~ Table3.
The database " fingerprint " of this configuration file of DatabaseSig=correspondence (comprises title and version, form coding with ProductName _ version number), if this configuration file is supported the several data storehouse, or a plurality of versions of certain database, then this project is listed the product " fingerprint " that all these configuration files are suitable for, and the centre is cut apart with comma.Next be the description of each monitored variable and the description of each monitoring form.The description of each monitored variable and the description of each monitoring form respectively account for a joint.The section name of monitored variable is the Var+ numeral number, as " Var3 ", comprises following project in the joint:
Type---types of variables, field type are the corresponding types of field at database declaration, such as INTEGER, CHAR (5) etc.
Cond---SQL statement is used for screening the employed condition of this variable.
Obj_ect_value---which field that appointment is taken out from SQL statement is obtained variate-value.
■ 0---and RunOnce, only gather a secondary data when starting
■ 1---and RepUpdate, periodic sampling only keeps last data.
■ 2---and RepStore, periodic sampling keeps sampling at every turn.
For the monitoring form, each joint comprises the description of a monitoring form equally, and section name is encoded to " Table "+numeral, as " Table3 ".Comprise following project in the joint:
SQL---optional, if this is arranged, then Biao query statement is this SQL statement, if this item not, then system uses whole fields to construct query statement automatically.
COL? form be:
Column_name Column_Type Column_Description
Wherein
Column_name is the data type of row for row name, Column_Type, and Column_Description describes for row.Because can use almost any character among Column_name and the Column_description, reserve the width of 30 bytes in the configuration file for Column_name, be Column_type afterwards, and Column_type is for fixing 4 byte wides, be Column_description afterwards, up to the row end.If certain field length deficiency is then filled vacant part with the space.
Use above-mentioned configuration file, just can the monitoring content of all databases be described, be used to extract monitor data.
3) monitor message data of database tissue.
Because two types monitor message is arranged, the monitor message database must be able to hold every type.For monitored variable, can adopt following tables of data to describe:
A. performance data table sysperfinfo has following field:
UpdateTIME | The TimpStamp type, the record data acquisition time |
DBID | Integer, database ID |
FEILDID | Integer is to the ID of dependent variable |
VALUE | Character string type writes down the value of this variable |
B. performance data description list sysperfdes has following field:
FEILDID | Integer is to dependent variable ID |
DES | Character string type, the variable functional description |
CLASS | Integer, the functional classification of this variable |
THRESHOLD1 | Floating type, threshold value 1 |
THRESHOLD2 | Floating type, threshold value 2 |
DIR | Integer, condition |
Illustrate: threshold value 1 and threshold value 2 are two floating numbers, for the variable of numeric type, have stipulated boundary, if the boundary of being higher or lower than, (the alarm action has two kinds: slight and high severity alarm then to trigger the alarm action.If crossed first threshold value, then trigger slight alarm, otherwise trigger high severity alarm still not to second threshold value.Because the numeric type variable has different growing directions, so establish a direction variable in addition, its direction is determined by DIR).DIR indicates the comparative approach with threshold value, if DIR is 1, then the value of explanatory variable is the smaller the better, when variate-value<=threshold value 1, does not trigger warning; When threshold value 1<variate-value<=threshold value 2, trigger slightly alarm; When variate-value>threshold value 2, trigger high severity alarm.
C. performance data classification sysperfclass has following field:
CLASS | Integer, the fields function classification |
DES | Character string type, the description of this classification |
For the monitoring form, system uses another mode to store: the form of setting up a similar, and increase database ID (DBID) field and time field (UpdateTime), the database ID of record performance data correspondence and the update time of data respectively.Be an example of configuration file below:
[Main]
VariableNum=3
TableNum=2
DatabaseSig=oracle_8
[Var1]
VarID=10001
VarName=logons?cumulative
Type=0
Class=7
Description=logons?cumulative
SQL=select?valuefrom?v$sysstat?where?name=′logons?cumulative′
object_value=value
UpdateMethod=2
[Var2]
VarID=10002
VarName=logons?current
Type=0
Class=7
Description=logons?current
SQL=select?value?from?v$sysstat?where?name=′logons?current′
object_value=value
UpdateMethod=2
[Var3]
VarID=10003
VarName=opened?cursors?cumulative
Type=0
Class=7
Description=opened?cursors?cumulative
SQL=select?valuefrom?v$sysstat?where?name=′opened?cursors?cumulative′
object_value=value
UpdateMethod=2
[Table1]
TableName=V$BUFFER_POOL_STATISTICS
UpdateMethod=1
COLNUM=19
COL1=ID 0 Buffer?poolID?number
COL2=NAME 1 Buffer?pool?name
COL3=SET_MSIZE 0 Buffer?pool?maximum?set?size
COL4=CNUM_REPL 0 Number?of?buffers?on?replacement?list
COL5=CNUM_WRITE 0 Number?of?buffers?on?write?list
COL6=CNUM_SET 0 Number?ofbuffers?in?set
COL7=BUF_GOT 0 Number?of?buffers?gotten?by?the?set
COL8=SUM_WRITE 0 Number?of?buffers?written?by?the?set
COL9=SUM_SCAN 0 Number?of?buffers?scanned?in?the?set
COL10=FREE_BUFFER_WAIT 0 Free?buffer?wait?statistic
COL11=WRITE_COMPLETE_WAIT 0 Write?complete?wait?statistic
COL12=BUFFER_BUSY_WAIT 0 Buffer?busy?wait?statistic
COL13=FREE_BUFFER_INSPECTED 0 Free?buffer?inspected?statistic
COL14=DIRTY_BUFFERS_SPECTED 0 Dirty?buffers?inspected?statistic
COL15=DB_BLOCK_CHANGE 0 Database?blocks?changed?statistic
COL16=DB_BLOCK_GETS 0 Database?blocks?gotten?statistic
COL17=CONSISTENT_GETS 0 Consistent?gets?statistic
COL18=PHYSICAL_READS 0?Physical?reads?statistic
COL19=PHYSICAL_WRITES 0?Physical?writes?statistic
[Table2]
TableName=V$RSRC_CONSUMER_GROUP
UpdateMethod=1
COLNUM=9
COL1=NAME 1 Name?of?the?consumer?group
COL2=ACTIVE_SESSIONS 0 Number?of?currently?active?sessions?in?this?group
COL3=EXECUTION_WAITERS 0 Number?of?currently?waiting?sessions
COL4=REQUESTS 0 Cumulative?number?of?requests
COL5=CPU_WAIT_TIME 0 Cumulative?amount?of?time?that?sessions?waited?for?CPU
COL6=CPU_WAITS 0 Cumulative?number?of?times?all?sessions?waited?for?CPU
COL7=CONSUMED_CPU_TIME 0 Cumulative?amount?of?CPU?time?consumed?by?all
sessions
COL8=YIELDS 0 Cumulative?number?oftimes?sessions?yield?the?CPU
COL9=SESSIONS_QUEUED 0 Reserved?for?future?use
3) parsing of configuration file and optimization
The configuration file parsing module is reading database performance monitoring configuration information from the monitor data configuration file, through the optimization of rule optimization module, produces monitored variable set and monitoring form set.
As shown in Figure 1, among the figure
(1) monitor data configuration file, for describing the configuration file of monitored database performance data, configuration file has a plurality of, one or more versions of the corresponding one or more products of each file.
(2) configuration file parsing module carries out syntax check to configuration file, and read wherein monitored variable and the configuration information of monitoring form.
(3) rule optimization module, the configuration information that the configuration file parsing module is read is optimized, and mainly is to set up incidence relation for the monitored variable with the different SQL statement of condition part only, to reduce the execution number of times of SQL statement.
(4) monitored variable is gathered, and has write down the information (type, acquisition methods etc.) of all monitored variable that will monitor.
(5) monitoring form is gathered, and has write down the information (how many fields are arranged, and what field type is respectively, how to obtain data etc.) of all monitoring forms that will monitor.
4) performance data reading and handling
The monitor task control module is controlled the behavior of some monitor data read modules, and data read module reads performance data according to monitored variable set and monitoring form set from monitored database, writes the monitor message database.
As shown in Figure 2, among the figure
(6) monitor task control module is the top control module of monitor task, is responsible for the establishment of monitor task and stops.For each database object that will monitor, it all creates a task, and passes to the database product " fingerprint " of Mission Monitor object, is used to obtain monitor data.
(7) monitor data read module is responsible for reading of monitor data.After it is created by (6) monitor task control module, obtain to want " fingerprint " of monitor database object, and obtain to want the monitored variable of monitor database object to gather and monitoring form is gathered, and carry out performance monitoring in view of the above according to fingerprint from the monitor task control module.
(8) monitored database is the database that will monitor, can be various type of database.
(9) monitor message database is used for record to (8) monitored database monitoring data, prepares against and consults, or in time up-set condition is alarmed.
The execution flow process of monitor task as shown in Figure 3, key step has:
(1) the new monitor data read module of monitor task control module establishment is monitored monitored database.
(2) the monitor data read module obtains to want " fingerprint " of monitor database object from the monitor task control module, and obtains to want the monitored variable of monitor database object to gather and monitoring form is gathered according to fingerprint, and carries out performance monitoring in view of the above.
(3) if all monitored variable are all handled, then change (9)
(4) obtain next monitored variable information.
(5), then change (3) if the value of this monitored variable is being read by same SQL statement before
(6) read variate-value according to the SQL statement in the monitored variable, read other variate-values that same SQL statement can read (promptly ignoring the variate-value that the condition part branch of SQL statement can read) simultaneously
(7) data that read are handled (as writing the monitor message database, alarm etc.)
(8) change (3)
(9) if all monitoring forms are all handled, change (14)
(10) obtain next monitoring form information
(11) by specifying SQL statement to read monitor message in the table
(12) data that read are handled (as writing the monitor message database, alarm etc.)
(13) change (9)
(14) cease and desist order commentaries on classics (17) if receive
(15) dormancy designated time intervals (sampling interval)
(16) change (3)
(17) stop.
Claims (4)
1. the non-proxy unified method for monitoring of a database performance, it is characterized in that using configuration file to describe the database of various needs monitoring, and using unified watchdog routine, the monitor data item according to configuration file is described connects the reading database performance data by network; After obtaining performance data, it with the threshold of predesignating, is triggered the alarm action if desired; Simultaneously in the data write performance database.
2. the non-proxy unified method for monitoring of a kind of database performance according to claim 1, it is characterized in that described configuration file: comprised the various information of monitor database object data item in the configuration file, comprised the sign of information, data item of monitored database and classification, the type of data item, the acquisition methods of data item occurrence; Data item is divided into two classes, is respectively monitored variable and smooth table; Configuration file adopts the common ini file form of Windows operating system.
3. the non-proxy unified method for monitoring of a kind of database performance according to claim 1, it is characterized in that described watchdog routine: after watchdog routine reads configuration file, the SQL statement that reads the monitor data item is optimized, merge the identical statement of main part, to reduce influence to monitored database; Watchdog routine is compared data after obtaining monitor data with pre-set threshold, the data item that exceeds threshold value alarmed, and all data item write performance databases.
4. the non-proxy unified method for monitoring of a kind of database performance according to claim 1, it is characterized in that described performance database: the table in the performance database is divided into two classes, for smooth table, there is structure with it identical but increased the tables of data of time and monitored Database Identification field; For monitored variable, three tables are arranged in the performance database, the monitor data of the description of classification, variable of variable and threshold value, variable is described respectively.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN 200710067200 CN101013442A (en) | 2007-02-07 | 2007-02-07 | Non-proxy unified method for monitoring performance of data base |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN 200710067200 CN101013442A (en) | 2007-02-07 | 2007-02-07 | Non-proxy unified method for monitoring performance of data base |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101013442A true CN101013442A (en) | 2007-08-08 |
Family
ID=38700954
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN 200710067200 Pending CN101013442A (en) | 2007-02-07 | 2007-02-07 | Non-proxy unified method for monitoring performance of data base |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101013442A (en) |
Cited By (25)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101446914B (en) * | 2007-11-26 | 2011-01-19 | 阿里巴巴集团控股有限公司 | Database monitoring method and device |
CN101989283A (en) * | 2009-08-04 | 2011-03-23 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
CN102567531A (en) * | 2011-12-30 | 2012-07-11 | 互动在线(北京)科技有限公司 | General method for monitoring status of light database |
CN102882701A (en) * | 2012-08-14 | 2013-01-16 | 深圳供电局有限公司 | Alarm system and method for intelligently monitoring power grid core service data |
CN103412911A (en) * | 2013-08-02 | 2013-11-27 | 中国工商银行股份有限公司 | Method and device for monitoring performance of database system |
CN103605722A (en) * | 2013-11-15 | 2014-02-26 | 北京奇虎科技有限公司 | Method, device and equipment for database monitoring |
CN103885995A (en) * | 2012-12-21 | 2014-06-25 | 中国移动通信集团河北有限公司 | List-based database monitoring method and list-based database monitoring device |
CN103927172A (en) * | 2014-04-15 | 2014-07-16 | 浪潮电子信息产业股份有限公司 | Implementation method of server detection tool based on safety USB flash drive |
CN104063301A (en) * | 2014-07-02 | 2014-09-24 | 网神信息技术(北京)股份有限公司 | Monitoring method and device |
WO2015024336A1 (en) * | 2013-08-20 | 2015-02-26 | 京东方科技集团股份有限公司 | Device fault warning method and device, and cim system |
CN105530145A (en) * | 2015-12-23 | 2016-04-27 | 中国电子科技集团公司第三十研究所 | Agentless equipment monitoring network based on ZABBIX framework, networking method and monitoring method |
CN105656642A (en) * | 2014-11-03 | 2016-06-08 | 北京确安科技股份有限公司 | Method for realizing authority management of integrated circuit test management system with INI |
CN105989137A (en) * | 2015-02-27 | 2016-10-05 | 中国移动通信集团河北有限公司 | Structured query language performance optimization method and system |
CN106407453A (en) * | 2016-09-30 | 2017-02-15 | 郑州云海信息技术有限公司 | Performance data management method and system |
CN107179977A (en) * | 2017-05-10 | 2017-09-19 | 杭州铭师堂教育科技发展有限公司 | Database Full-automatic monitoring system based on mpm models |
CN107220301A (en) * | 2017-05-10 | 2017-09-29 | 北京小度信息科技有限公司 | The data monitoring method and device of a kind of configurableization |
CN107402232A (en) * | 2017-08-11 | 2017-11-28 | 中北大学 | The dynamic blast absolute rating assay method of fuel gas |
CN107506450A (en) * | 2017-08-28 | 2017-12-22 | 深圳市华傲数据技术有限公司 | A kind of method and device for being used to solve the access of data high concurrent |
CN108509321A (en) * | 2017-02-24 | 2018-09-07 | 北京京东尚科信息技术有限公司 | Generate the monitoring method and system of data cube |
CN110795451A (en) * | 2019-09-18 | 2020-02-14 | 平安科技(深圳)有限公司 | SQL fingerprint restoration method and device, computer equipment and storage medium |
CN112650656A (en) * | 2019-10-09 | 2021-04-13 | 北京京东尚科信息技术有限公司 | Performance monitoring method, device, equipment, server and storage medium |
CN112835768A (en) * | 2021-02-25 | 2021-05-25 | 紫光云技术有限公司 | Real-time monitoring resource measurement data method based on ceilometer |
CN113051120A (en) * | 2019-12-26 | 2021-06-29 | 医渡云(北京)技术有限公司 | Data monitoring method and device, readable medium and electronic equipment |
CN114143242A (en) * | 2021-11-29 | 2022-03-04 | 中能融合智慧科技有限公司 | Agent-free monitoring network equipment monitoring system, equipment and storage medium |
CN115221009A (en) * | 2022-09-19 | 2022-10-21 | 中国人寿保险股份有限公司上海数据中心 | Monitoring and alarming integrated system of credit creation database and implementation method thereof |
-
2007
- 2007-02-07 CN CN 200710067200 patent/CN101013442A/en active Pending
Cited By (36)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101446914B (en) * | 2007-11-26 | 2011-01-19 | 阿里巴巴集团控股有限公司 | Database monitoring method and device |
CN101989283A (en) * | 2009-08-04 | 2011-03-23 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
CN101989283B (en) * | 2009-08-04 | 2014-06-11 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
CN102567531B (en) * | 2011-12-30 | 2014-07-30 | 互动在线(北京)科技有限公司 | General method for monitoring status of light database |
CN102567531A (en) * | 2011-12-30 | 2012-07-11 | 互动在线(北京)科技有限公司 | General method for monitoring status of light database |
CN102882701A (en) * | 2012-08-14 | 2013-01-16 | 深圳供电局有限公司 | Alarm system and method for intelligently monitoring power grid core service data |
CN102882701B (en) * | 2012-08-14 | 2015-07-29 | 深圳供电局有限公司 | A kind of electrical network core business data intelligent monitoring warning system and method |
CN103885995B (en) * | 2012-12-21 | 2017-05-03 | 中国移动通信集团河北有限公司 | List-based database monitoring method and list-based database monitoring device |
CN103885995A (en) * | 2012-12-21 | 2014-06-25 | 中国移动通信集团河北有限公司 | List-based database monitoring method and list-based database monitoring device |
CN103412911B (en) * | 2013-08-02 | 2016-08-10 | 中国工商银行股份有限公司 | The method for monitoring performance of Database Systems and device |
CN103412911A (en) * | 2013-08-02 | 2013-11-27 | 中国工商银行股份有限公司 | Method and device for monitoring performance of database system |
WO2015024336A1 (en) * | 2013-08-20 | 2015-02-26 | 京东方科技集团股份有限公司 | Device fault warning method and device, and cim system |
CN103605722A (en) * | 2013-11-15 | 2014-02-26 | 北京奇虎科技有限公司 | Method, device and equipment for database monitoring |
CN103605722B (en) * | 2013-11-15 | 2018-11-06 | 北京奇虎科技有限公司 | Database monitoring method and device, equipment |
CN103927172A (en) * | 2014-04-15 | 2014-07-16 | 浪潮电子信息产业股份有限公司 | Implementation method of server detection tool based on safety USB flash drive |
CN103927172B (en) * | 2014-04-15 | 2019-03-08 | 浪潮电子信息产业股份有限公司 | A kind of server detection instrument implementation method of safe U disc |
CN104063301A (en) * | 2014-07-02 | 2014-09-24 | 网神信息技术(北京)股份有限公司 | Monitoring method and device |
CN105656642A (en) * | 2014-11-03 | 2016-06-08 | 北京确安科技股份有限公司 | Method for realizing authority management of integrated circuit test management system with INI |
CN105989137B (en) * | 2015-02-27 | 2019-12-10 | 中国移动通信集团河北有限公司 | Method and system for optimizing structured query language performance |
CN105989137A (en) * | 2015-02-27 | 2016-10-05 | 中国移动通信集团河北有限公司 | Structured query language performance optimization method and system |
CN105530145A (en) * | 2015-12-23 | 2016-04-27 | 中国电子科技集团公司第三十研究所 | Agentless equipment monitoring network based on ZABBIX framework, networking method and monitoring method |
CN106407453A (en) * | 2016-09-30 | 2017-02-15 | 郑州云海信息技术有限公司 | Performance data management method and system |
CN108509321A (en) * | 2017-02-24 | 2018-09-07 | 北京京东尚科信息技术有限公司 | Generate the monitoring method and system of data cube |
CN107220301A (en) * | 2017-05-10 | 2017-09-29 | 北京小度信息科技有限公司 | The data monitoring method and device of a kind of configurableization |
CN107179977B (en) * | 2017-05-10 | 2018-07-17 | 杭州铭师堂教育科技发展有限公司 | Database Full-automatic monitoring system based on mpm models |
CN107179977A (en) * | 2017-05-10 | 2017-09-19 | 杭州铭师堂教育科技发展有限公司 | Database Full-automatic monitoring system based on mpm models |
CN107402232A (en) * | 2017-08-11 | 2017-11-28 | 中北大学 | The dynamic blast absolute rating assay method of fuel gas |
CN107402232B (en) * | 2017-08-11 | 2023-03-21 | 中北大学 | Method for measuring dynamic explosion limit parameters of combustible gas |
CN107506450A (en) * | 2017-08-28 | 2017-12-22 | 深圳市华傲数据技术有限公司 | A kind of method and device for being used to solve the access of data high concurrent |
CN110795451A (en) * | 2019-09-18 | 2020-02-14 | 平安科技(深圳)有限公司 | SQL fingerprint restoration method and device, computer equipment and storage medium |
CN110795451B (en) * | 2019-09-18 | 2023-05-16 | 平安科技(深圳)有限公司 | SQL fingerprint restoring method, SQL fingerprint restoring device, SQL fingerprint restoring computer equipment and storage medium |
CN112650656A (en) * | 2019-10-09 | 2021-04-13 | 北京京东尚科信息技术有限公司 | Performance monitoring method, device, equipment, server and storage medium |
CN113051120A (en) * | 2019-12-26 | 2021-06-29 | 医渡云(北京)技术有限公司 | Data monitoring method and device, readable medium and electronic equipment |
CN112835768A (en) * | 2021-02-25 | 2021-05-25 | 紫光云技术有限公司 | Real-time monitoring resource measurement data method based on ceilometer |
CN114143242A (en) * | 2021-11-29 | 2022-03-04 | 中能融合智慧科技有限公司 | Agent-free monitoring network equipment monitoring system, equipment and storage medium |
CN115221009A (en) * | 2022-09-19 | 2022-10-21 | 中国人寿保险股份有限公司上海数据中心 | Monitoring and alarming integrated system of credit creation database and implementation method thereof |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101013442A (en) | Non-proxy unified method for monitoring performance of data base | |
US11609895B2 (en) | Methods and systems for appending data to large data volumes in a multi-tenant store | |
KR102575007B1 (en) | Queries against external tables in the database system | |
US7096231B2 (en) | Export engine which builds relational database directly from object model | |
JP6388655B2 (en) | Generation of multi-column index of relational database by data bit interleaving for selectivity | |
US20180150529A1 (en) | Event driven extract, transform, load (etl) processing | |
US20110258225A1 (en) | Methods and Systems for Performing Transparent Object Migration Across Storage Tiers | |
US8135763B1 (en) | Apparatus and method for maintaining a file system index | |
CN105447184A (en) | Information capturing method and device | |
CN107943991A (en) | A kind of distributed reptile frame and implementation method based on memory database | |
US10860562B1 (en) | Dynamic predicate indexing for data stores | |
CA2526882A1 (en) | Method and system for reducing information latency in a business enterprise | |
CN102622443A (en) | Customized screening system and method for microblog | |
US7415467B2 (en) | Database replication system | |
CN101937474A (en) | Mass data query method and device | |
CN113849483A (en) | Real-time database system architecture for intelligent factory | |
CN107800808A (en) | A kind of data-storage system based on Hadoop framework | |
CN101751642A (en) | Electronic commerce market product/service information management and monitoring platform | |
CN109783315A (en) | A kind of database platform automation method for inspecting and system | |
US8965879B2 (en) | Unique join data caching method | |
CN106547538A (en) | A kind of intelligent operation management system based on Django | |
CN109981627A (en) | The update method and system of Cyberthreat information | |
US6456998B1 (en) | Efficient processing of parent-child relationships in a relational database management system | |
CN107104806A (en) | Call bill processing method, apparatus and system | |
US7054862B2 (en) | Method and system for long-term update and edit control in a database system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |