CN102156729A - System and method for monitoring database servers - Google Patents
System and method for monitoring database servers Download PDFInfo
- Publication number
- CN102156729A CN102156729A CN2011100857887A CN201110085788A CN102156729A CN 102156729 A CN102156729 A CN 102156729A CN 2011100857887 A CN2011100857887 A CN 2011100857887A CN 201110085788 A CN201110085788 A CN 201110085788A CN 102156729 A CN102156729 A CN 102156729A
- Authority
- CN
- China
- Prior art keywords
- data
- request
- database
- user interface
- surveillance center
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
-
- 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/3006—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system is distributed, e.g. networked systems, clusters, multiprocessor systems
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/06—Generation of reports
Abstract
The invention provides a system and a method for monitoring a plurality of database servers. The system comprises a plurality of acquisition modules, a monitoring center and a user interface, wherein each of the acquisition modules is arranged on one of the plurality of database servers and used for acquiring data with an appointed monitoring index and storing the acquired data into a database of the database server where the acquisition module is positioned; the monitoring center is connected with the plurality of acquisition modules through a network; and the user interface is used for receiving a request from a user and submitting the received request to the monitoring center. In response to the request from the user interface, the monitoring center acquires the data from the database of the corresponding database server or data storage of the monitoring center, and returns the acquired data to the user interface so as to display the acquired data.
Description
Technical field
The present invention relates generally to the server monitoring field, more particularly, the present invention relates to a kind of system and method for monitoring a plurality of database servers.
Background technology
Along with the widespread use of computing machine, need the database server monitored more and more in the enterprise, the enterprise that for example has may need to monitor tens even a hundreds of database server.For monitoring database server, employing signs in to the mode of each database server respectively usually.In this way, monitoring database server is consuming time long, and can not the current resource consumption situation of a plurality of database servers be compared.
Though also developed at present the instrument of monitoring server, hardware performance that can only monitoring server, and can not monitor other information of database level.In addition, have shortcomings such as configuration complexity, difficult use for already present server monitoring instrument.
Summary of the invention
In order to solve above-mentioned shortcoming of the prior art and problem the present invention is proposed.
According to an aspect of the present invention, a kind of system that monitors a plurality of database servers is provided, described system comprises: a plurality of acquisition modules, each described acquisition module is deployed in described a plurality of database server one, be responsible for to gather the data of the monitor control index of appointment, and with the data storage of the being gathered database at the database server that acquisition module was arranged in; Surveillance center, described Surveillance center is connected with described a plurality of acquisition modules by network; And user interface, be used to receive request from the user, and described Surveillance center is submitted in the request that is received, wherein, in response to the request from described user interface, described Surveillance center obtains data, and obtained data is returned to described user interface to show from the database of respective database servers or from the data storage of described Surveillance center.
According to an aspect, when the request from described user interface was request to real-time monitor data, described Surveillance center was connected to respective database servers, obtains data from the database of described respective database servers, and obtained data is returned to described user interface to show according to described request.
According to an aspect, described Surveillance center further comprises data processing module, wherein, described data processing module at the fixed time or according to predetermined space from the database of described a plurality of database servers extract data, data storage after data are handled and will be handled is described data storage.
According to an aspect, when the request from described user interface was request to historical monitor data, described Surveillance center obtained data, and obtained data is returned to described user interface to show from described data storage according to described request.
According to an aspect, described Surveillance center further comprises alarm module, and wherein, when in the described monitor control index any one reaches the threshold value of setting, described alarm module will send warning message.
According to an aspect, described monitor control index comprises one or more in following: speed, percent of Log Space Used, CPU, disk space, internal memory, data sync state and flow that database caches hit rate, active transaction, batch request, network wait, lock, user connect, scan.
According to another aspect of the present invention, a kind of method of monitoring a plurality of database servers is provided, described method comprises: the data of gathering the monitor control index of appointment by the acquisition module that is deployed on each in described a plurality of database server, and with the data storage of being gathered in the database of database server; By the request of user interface reception from the user; Surveillance center is submitted in the request that is received, in response to request, obtain data, and obtained data returned to described user interface to show from the database of respective database servers or from the data storage of described Surveillance center by described Surveillance center from described user interface.
According to an aspect, when the request from described user interface is request to real-time monitor data, is connected to respective database servers, from the database of described respective database servers, obtains data, and obtained data returned to described user interface to show according to described request by described Surveillance center.
According to an aspect, further comprise: at the fixed time or according to predetermined space by data processing module from the database of described a plurality of database servers extract data, data storage after data are handled and will be handled is data storage.
According to an aspect, further comprise: when the request from described user interface is request to historical monitor data, from described data storage, obtains data, and obtained data returned to described user interface to show according to described request by described Surveillance center.
According to an aspect, further comprise: when in the described monitor control index any one reaches the threshold value of setting, send warning message by alarm module.
According to an aspect, wherein said monitor control index comprises one or more in following: speed, percent of Log Space Used, CPU, disk space, internal memory, data sync state and flow that database caches hit rate, active transaction, batch request, network wait, lock, user connect, scan.。
Description of drawings
By the description of carrying out below in conjunction with accompanying drawing, above-mentioned and other aspects of some one exemplary embodiment of the present invention, feature and advantage will become apparent to those skilled in the art, wherein:
Fig. 1 is the block diagram that the system of an one exemplary embodiment according to the present invention is shown;
Fig. 2 is the synoptic diagram that the monitored object setting of the one exemplary embodiment according to the present invention is shown;
Fig. 3 is the synoptic diagram that the database user linking number of the one exemplary embodiment according to the present invention is shown;
Fig. 4 is the synoptic diagram that the real-time monitoring of single cpu of the one exemplary embodiment according to the present invention is shown;
Fig. 5 is the synoptic diagram that the disk space history of the one exemplary embodiment according to the present invention is shown;
Fig. 6 is the synoptic diagram that a plurality of cpu monitors of one exemplary embodiment according to the present invention are shown; And
Fig. 7 is the process flow diagram that the method for one exemplary embodiment according to the present invention is shown.
Embodiment
Describing below to help complete understanding one exemplary embodiment of the present invention with reference to the accompanying drawings is provided.It comprises various details to help understanding, and they should be thought it only is exemplary.Therefore, those of ordinary skills will be appreciated that, can make various changes and modification to the embodiments described herein, and can not deviate from scope and spirit of the present invention.Equally, for clarity and conciseness, omitted description to known function and structure.
Describe the present invention below with reference to the accompanying drawings in detail.
Fig. 1 is the block diagram that the system of an one exemplary embodiment according to the present invention is shown.This system comprise a plurality of monitored object 110-1,110-2 ..., 110-N, Surveillance center 120, user interface 130.
Monitored object 110-1,110-2 ..., 110-N each be database server, be deployed with respectively on each at it acquisition module 112-1,112-2 ..., 112-N.Acquisition module is responsible for the data of acquisition monitoring index.
According to the present invention, monitor control index can comprise the index relevant with database, for example linking number, database size, deadlock, data sync state etc.; Monitor control index also can comprise the index relevant with the hardware of monitored object itself, for example relevant index such as CPU, hard disk, internal memory, network interface card.
By carrying out specific operating system command and database instruction, acquisition module can be collected the data of acquisition index according to predefined frequency acquisition, and the information stores that collects the database of the monitored object that it was positioned at (for example, database 114-1, the 114-2 shown in Fig. 1 ..., 114-N) in.
For example, under the situation of operation SqlServer database on the monitored object, acquisition module can by sqlserver:buffer manager Buffer cache hit ratio gather the data relevant with the database caches hit rate; By sqlserver:databases (_ Total) Active Transactions gather the data relevant with active transaction; By sqlserver:sql statistics BatchRequests/sec gather and batch ask relevant data; By sqlserver:wait statistics (the accumulation stand-by period (ms) of per second) Network IO waits collection network wait for relevant data; By sqlserver:locks (_ Total) Lock Wait Time (ms) gather the data of phase-locked pass; By sqlserver:general statistics User Connections gather data with user's join dependency; By SQLServer:Databases (_ Total) DBCC Logical Scan Bytes/sec gather and the relevant data of speed that scan; By SQLServer:Databases (tempdb) Percent Log Used gather the data relevant with percent of Log Space Used; By processor (_ total) %processor time gather the data relevant with CPU; By Network Interface (Ms TCP Loopback interface) BytesTotal/sec gather the data relevant with flow; Gather the data relevant by xp_fixeddrives with disk space; Gather the data relevant by sp_replmonitorhelpsubscription with the monitor data synchronizing relay.The present invention also can gather the data relevant with other monitor control index.
Be that example is illustrated with the SqlServer database in the above, but the invention is not restricted to the SqlServer database, it also can be applied to other database, such as MySql, oracle database etc.Those skilled in the art are according to instruction of the present invention, can easily adopt appropriate operating system order and database instruction gather other database about the data of above-mentioned monitor control index and about the data of other monitor control index.
In addition, acquisition module should be selected suitable frequency when the data of acquisition monitoring index.Frequency acquisition is too high can to consume the resource of too much monitored object, and may cause collection result too huge; Frequency acquisition is crossed low meeting and is omitted the collection point, causes image data can not react objective reality.In one embodiment of the invention, the frequency acquisition (for example 30 seconds) of expectation can be arranged in the configuration parameter file.Certainly, as known to those skilled in the art, also can adopt alternate manner that frequency acquisition is set.
And, because that the related acquisition index of each monitored object reaches is up to a hundred, if to all acquisition index image data then may influence the efficient of collection.Therefore, in one embodiment of the invention, the acquisition index of being concerned about can be arranged in the configuration parameter file.Certainly, as known to those skilled in the art, also can adopt alternate manner that the acquisition index of care is set.
Therefore, acquisition module can be collected data according to set frequency and acquisition index.
Monitored object 110-1,110-2 ..., 110-N each can be connected with Surveillance center 120 by network (not shown) such as LAN (Local Area Network) (" LAN "), wide area network (" WAN ") and the Internet etc.
Surveillance center 120 can be responsible for the maintenance of the monitor channel between Surveillance center 120 and monitored object 110.Monitor channel is in idle state after configuration successful, only just can open in needs, safeguards monitor channel in the database aspect in the present invention.For example, when Surveillance center 120 receive from user interface 130 (will be introduced in the back) to the request of real-time monitor data the time, Surveillance center will open and the monitor channel that arrives corresponding monitored object, from the database of corresponding monitored object, obtain data, and obtained data are returned to user interface to show.
Surveillance center 120 can also comprise data processing module 122 and data storage 124.Data processing module 122 can the data of being extracted are handled, and the data storage after will handling be in data storage 124 in the time of appointment or according to the automatic data of extracting in the database 114 that is stored in monitored object 110 of predetermined cycle.
For example, data processing module 122 can extract the monitor data of storing in the database 114 of each monitored object 110 automatically 12 of every nights, the data of being extracted about each monitor control index are calculated mean value, maximal value, minimum value by the hour, and the mean value of each monitor control index that will calculate by the hour, maximal value, minimum value are stored in the data storage 124.
Certainly, the invention is not restricted to the mode of above-mentioned example.As required, can carry out various variations.For example, can extract data automatically at noon every day and every night, also (for example two hours) extract data automatically for example at set intervals; Can only calculate the mean value of each monitor control index and not calculate maximal value or minimum value; Also can or year wait the monitor data that is extracted is handled by 10 minutes, half an hour, two hour, day, months.
After from database 114, extracting monitor data, the corresponding monitor data in the delete database 114 immediately, can be not yet the corresponding monitor data (for example, the corresponding monitor data of deletion after 1 month) in the delete database 114 immediately.
Surveillance center 120 can also comprise alarm module 126, whether its each monitor control index of monitoring each monitored object reaches the threshold value of setting, when monitor control index reaches the threshold value of setting, then send warning message (such as sending warning message) by Short Message Service.Sharp as, alarm module 126 sends warning messages automatically when CPU usage reaches 80%, alarm module 126 sends warning messages automatically when the disk free space is lower than 10G, alarm module 126 sends warning messages or the like automatically when the data sync time-delay reaches 10 minutes.All threshold values can be arranged in the configuration parameter file of Surveillance center 120, maybe can be arranged in the database of Surveillance center 120.
For example, user interface 130 can generate the interface that monitored object is provided with, and shows all objects to be monitored and the check box that can supply the user to select in this interface.After the user has selected to wish the monitored object of monitoring, can be by pressing for example save button, thus preserve the monitored object that the user is provided with.
Those skilled in the art are with clear, and user interface 130 can show various user interfaces as required.
Fig. 2-Fig. 6 shows the exemplary user interface that user interface 130 can generate.
Fig. 2 shows exemplary monitored object the interface is set.As shown in FIG. 2, the IP address of monitored object (being database server) has been shown in the Serverip hurdle, the server name of monitored object has been shown in the Servername hurdle, whether monitored check box has been shown in the hurdle.The user can choose the corresponding check box of the monitored object of wishing monitoring.According to an embodiment, monitored object that can adopt different forms to show to choose and unselected monitored object (for example, by different colors, different font etc.).According to an embodiment, can adopt different forms to come the monitored object at the current place of instructs cursor.Be provided with in the interface at monitored object, also comprise save button.When the user selects save button, promptly the monitored object of choosing can be added in the watch-list, or unchecked monitored object is deleted from watch-list.Be provided with in the interface at monitored object, can also comprise X button.When thinking, the user can press X button simply when not needing to revise being provided with of monitored object.
Fig. 3 shows database user linking number curve map.As shown in Figure 3, horizontal ordinate is represented the time, ordinate representation database user linking number.And, in Fig. 3, also show monitored object IP address (in Fig. 3, being 10.66.66.12) drop-down menu, monitor control index (in Fig. 3, connecting) drop-down menu, time period (being 500 seconds) drop-down menu in Fig. 3 for the user.The user can utilize these drop-down menus to select its monitored object, monitor control index and the time period length of wishing monitoring, and can click the Show Button and refresh demonstration behind the option of having selected its hope.In addition, in Fig. 3, provide the derivation button to come derived data, and provide X button to close current window.
Fig. 4 shows the real-time monitoring figure of the CPU of single monitored object.As shown in Figure 4, horizontal ordinate is represented the time, and ordinate is represented the processor utilization rate.And, in Fig. 4, also show monitored object IP address (in Fig. 4, being 10.66.66.12) drop-down menu, monitor control index (in Fig. 4, being processor %) drop-down menu, time period (being 500 seconds) drop-down menu in Fig. 4.The user can utilize these drop-down menus to select its monitored object, monitor control index and the time period length of wishing monitoring, and can click the Show Button and refresh demonstration behind the option of having selected its hope.In addition, in Fig. 4, provide the derivation button to come derived data, and provide X button to close current window.
Understand ground easily as art technology, when the monitor control index among Fig. 3 " user's connection " is changed into " processor % ", and click the Show Button, the figure in can displayed map 4.In other words, by changing the option of three drop-down menus, can easily change monitored object, monitor control index and time period length among the figure.
Fig. 5 shows Single-Server disk space history graphs.As shown in Figure 5, horizontal ordinate is represented the time, and ordinate is represented the disk remaining space.And, in Fig. 5, also show monitored object IP address (in Fig. 5, being 10.66.66.98) drop-down menu, monitor control index (in Fig. 5, being N) drop-down menu, zero-time (in Fig. 5, being 2010-10-25) drop-down menu and concluding time (in Fig. 5, being 2010-11-24).The user can utilize these drop-down menus to select its monitored object of wishing monitoring, monitor control index, monitoring zero-time, monitoring concluding time, and can click the Show Button and refresh demonstration behind the option of having selected its hope.In addition, in Fig. 5, provide the derivation button to come derived data, and provide X button to close current window.
The CPU that Fig. 6 shows many monitored object is monitoring figure in real time.As shown in Figure 6, show the cpu busy percentage (by the state indication) of a plurality of monitored object (indicating) by form, and time option (having selected nearest 5 minutes in Fig. 6) and CPU value option (having selected mean value in Fig. 6) are provided by server ip.In addition, can show different cpu busy percentages by different forms (for example color).
Fig. 7 shows the process flow diagram of the method for one exemplary embodiment according to the present invention.
In step S710, the data of gathering the monitor control index of appointment by the acquisition module that is deployed on each in a plurality of database servers, and with the data storage of being gathered in the database of database server.Describe the data of monitor control index how to gather appointment in detail about the acquisition module among Fig. 1 112 hereinbefore and, therefore no longer be described in detail at this to the storage of the data of being gathered.
In step S720, receive request by user interface from the user, can be to the detailed description of this step with reference to description to the user interface 130 of Fig. 1.
In step S730, Surveillance center is submitted in the request that is received.
In step S740, Surveillance center is in response to the request from described user interface, obtains data, and obtained data returned to described user interface to show from the database of respective database servers or from the data storage of described Surveillance center.
When described request is request to real-time monitor data, is connected to respective database servers, from the database of described respective database servers, obtains data, and obtained data returned to described user interface to show according to described request by described Surveillance center.
When described request is request to historical monitor data, obtain data from described data storage, and will obtained data return to described user interface showing according to described request by described Surveillance center, the data in the wherein said data storage are to handle from the database extraction data of described a plurality of database servers, to data by data processing module at the fixed time or according to predetermined space to obtain.
As an example, when Surveillance center receive from user interface to the request of the nearest 500 seconds database user linking number of server 10.66.66.12 the time, Surveillance center is opened to the passage of server 10.66.66.12, obtain the data of nearest 500 seconds database user linking number from this data in server storehouse, and obtained data are returned to described user interface, user interface can generate interface for example shown in Figure 3 according to the data that received.
As another example, when Surveillance center receive from user interface to the request of the remanence disk space during the 2010-10-25 to 2010-11-24 of server 10.66.66.98 the time, Surveillance center can obtain the data about the remanence disk space during the 2010-10-25 to 2010-11-24 of server 10.66.66.98 from the data storage of himself, and obtained data are returned to described user interface, user interface can generate interface for example shown in Figure 5 according to the data that received.
This method can also comprise: when in the described monitor control index any one reaches the threshold value of setting, send warning message by alarm module.
Ultimate principle of the present invention has below been described in conjunction with specific embodiments, but, it is to be noted, for those of ordinary skill in the art, can understand the whole or any steps or the parts of method and apparatus of the present invention, can be in the network of any calculation element (comprising processor, storage medium etc.) or calculation element, realized that with hardware, firmware, software or their combination this is that those of ordinary skills use their basic programming skill just can realize under the situation of having read explanation of the present invention.
Therefore, purpose of the present invention can also realize by program of operation or batch processing on any calculation element.Described calculation element can be known fexible unit.Therefore, purpose of the present invention also can be only by providing the program product that comprises the program code of realizing described method or device to realize.That is to say that such program product also constitutes the present invention, and the storage medium that stores such program product also constitutes the present invention.Obviously, described storage medium can be any storage medium that is developed in any known storage medium or future.
It is pointed out that also that in apparatus and method of the present invention obviously, each parts or each step can decompose and/or reconfigure.These decomposition and/or reconfigure and to be considered as equivalents of the present invention.And, carry out the step of above-mentioned series of processes and can order following the instructions naturally carry out in chronological order, but do not need necessarily to carry out according to time sequencing.Some step can walk abreast or carry out independently of one another, for example, to original vision content carry out the step of colour correction and the image that photographs carried out the step of geometry correction can be sequentially, carry out independently concurrently or with any order.
Above-mentioned embodiment does not constitute limiting the scope of the invention.Those skilled in the art should be understood that, depend on designing requirement and other factors, and various modifications, combination, sub-portfolio and alternative can take place.Any modification of being done within the spirit and principles in the present invention, be equal to and replace and improvement etc., all should be included within the protection domain of the present invention.
Claims (12)
- One kind the monitoring a plurality of database servers system, described system comprises:A plurality of acquisition modules, each described acquisition module is deployed in described a plurality of database server one, be responsible for to gather the data of the monitor control index of appointment, and with the data storage of the being gathered database at the database server that acquisition module was arranged in;Surveillance center, described Surveillance center is connected with described a plurality of acquisition modules by network; AndUser interface is used to receive the request from the user, and described Surveillance center is submitted in the request that is received,Wherein, in response to the request from described user interface, described Surveillance center obtains data, and obtained data is returned to described user interface to show from the database of respective database servers or from the data storage of described Surveillance center.
- 2. system according to claim 1, wherein:When the request from described user interface was request to real-time monitor data, described Surveillance center was connected to respective database servers, obtains data from the database of described respective database servers, and obtained data is returned to described user interface to show according to described request.
- 3. system according to claim 1, described Surveillance center further comprises data processing module,Wherein, described data processing module at the fixed time or according to predetermined space from the database of described a plurality of database servers extract data, data storage after data are handled and will be handled is described data storage.
- 4. system according to claim 3, wherein, when the request from described user interface was request to historical monitor data, described Surveillance center obtained data, and obtained data is returned to described user interface to show from described data storage according to described request.
- 5. system according to claim 1, described Surveillance center further comprises alarm module,Wherein, when in the described monitor control index any one reaches the threshold value of setting, described alarm module will send warning message.
- 6. system according to claim 1, wherein said monitor control index comprises one or more in following: speed, percent of Log Space Used, CPU, disk space, internal memory, data sync state and flow that database caches hit rate, active transaction, batch request, network wait, lock, user connect, scan.
- One kind the monitoring a plurality of database servers method, described method comprises:The data of gathering the monitor control index of appointment by the acquisition module that is deployed on each in described a plurality of database server, and with the data storage of being gathered in the database of database server;By the request of user interface reception from the user;Surveillance center is submitted in the request that is received,In response to request, obtain data, and obtained data returned to described user interface to show from the database of respective database servers or from the data storage of described Surveillance center by described Surveillance center from described user interface.
- 8. method according to claim 7, wherein, when the request from described user interface is request to real-time monitor data, is connected to respective database servers, from the database of described respective database servers, obtains data, and obtained data returned to described user interface to show according to described request by described Surveillance center.
- 9. method according to claim 7 further comprises:At the fixed time or according to predetermined space by data processing module from the database of described a plurality of database servers extract data, data storage after data are handled and will be handled is data storage.
- 10. method according to claim 9 further comprises:When the request from described user interface is request to historical monitor data, from described data storage, obtains data, and obtained data returned to described user interface to show according to described request by described Surveillance center.
- 11. method according to claim 7 further comprises: when in the described monitor control index any one reaches the threshold value of setting, send warning message by alarm module.
- 12. method according to claim 7, wherein said monitor control index comprise one or more in following: speed, percent of Log Space Used, CPU, disk space, internal memory, data sync state and flow that database caches hit rate, active transaction, batch request, network wait, lock, user connect, scan.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011100857887A CN102156729A (en) | 2011-03-29 | 2011-03-29 | System and method for monitoring database servers |
| PCT/CN2012/072144 WO2012130030A1 (en) | 2011-03-29 | 2012-03-09 | System and method for monitoring multiple database servers |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011100857887A CN102156729A (en) | 2011-03-29 | 2011-03-29 | System and method for monitoring database servers |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102156729A true CN102156729A (en) | 2011-08-17 |
Family
ID=44438228
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011100857887A Pending CN102156729A (en) | 2011-03-29 | 2011-03-29 | System and method for monitoring database servers |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN102156729A (en) |
| WO (1) | WO2012130030A1 (en) |
Cited By (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521390A (en) * | 2011-12-21 | 2012-06-27 | 北京人大金仓信息技术股份有限公司 | Database management and monitoring system based on pin function |
| CN102521339A (en) * | 2011-12-08 | 2012-06-27 | 北京京东世纪贸易有限公司 | System and method for dynamic access of data sources |
| CN102565296A (en) * | 2011-12-11 | 2012-07-11 | 天津大学 | On-line early warning system and early warning method for quality of raw water of water reclamation plant |
| CN102567531A (en) * | 2011-12-30 | 2012-07-11 | 互动在线（北京）科技有限公司 | General method for monitoring status of light database |
| CN102707026A (en) * | 2012-06-06 | 2012-10-03 | 天津大学 | Water reclamation plant raw water quality online early warning system and control method thereof |
| WO2012130030A1 (en) * | 2011-03-29 | 2012-10-04 | 北京京东世纪贸易有限公司 | System and method for monitoring multiple database servers |
| CN102821003A (en) * | 2011-12-07 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and system for patrolling system resource performances |
| CN102970183A (en) * | 2012-11-22 | 2013-03-13 | 浪潮(北京)电子信息产业有限公司 | Cloud monitoring system and data reflow method thereof |
| CN103186624A (en) * | 2011-12-31 | 2013-07-03 | 北京亿阳信通科技有限公司 | Data synchronization method and data synchronization device |
| CN103326958A (en) * | 2012-03-22 | 2013-09-25 | 鸿富锦精密工业（深圳）有限公司 | Method and system for monitoring data cache |
| CN103546331A (en) * | 2012-07-16 | 2014-01-29 | 中兴通讯股份有限公司 | Method, device and system for acquiring monitoring information |
| CN103888378A (en) * | 2014-04-09 | 2014-06-25 | 北京京东尚科信息技术有限公司 | Data exchange system and method based on cache mechanism |
| CN104615660A (en) * | 2015-01-05 | 2015-05-13 | 浪潮(北京)电子信息产业有限公司 | Method and system for monitoring database performance |
| CN104954201A (en) * | 2015-06-19 | 2015-09-30 | 上海卓悠网络科技有限公司 | Sampling method and sampling device for heath data of network and servers of IDC (Internet Data Center) |
| CN103107921B (en) * | 2013-02-01 | 2015-12-02 | 大唐移动通信设备有限公司 | Method for supervising and system |
| CN105183608A (en) * | 2015-08-14 | 2015-12-23 | 广东能龙教育股份有限公司 | Monitoring and early warning method for multiple databases |
| CN105912443A (en) * | 2016-04-12 | 2016-08-31 | 乐视控股（北京）有限公司 | Method and system for acquiring user's customized monitoring index data |
| CN106059794A (en) * | 2016-05-13 | 2016-10-26 | 努比亚技术有限公司 | Monitoring method and monitoring apparatus |
| CN107241242A (en) * | 2017-07-19 | 2017-10-10 | 北京奇艺世纪科技有限公司 | A kind of data processing method and device |
| CN107454369A (en) * | 2017-08-23 | 2017-12-08 | 广东电网有限责任公司佛山供电局 | A kind of ultra-high-tension power transmission line intelligent video monitoring system and its method of work |
| CN108667872A (en) * | 2017-03-31 | 2018-10-16 | 北京京东尚科信息技术有限公司 | Archiving method and device for dispatch server |
| CN108874626A (en) * | 2018-05-31 | 2018-11-23 | 泰康保险集团股份有限公司 | System monitoring method and apparatus |
| CN109408340A (en) * | 2018-11-06 | 2019-03-01 | 云宏信息科技股份有限公司 | Store monitoring method, the storage medium of equipment |
| CN109800136A (en) * | 2018-12-06 | 2019-05-24 | 珠海西山居移动游戏科技有限公司 | A kind of long-range redis performance data method of sampling and its system |
| CN109901971A (en) * | 2019-02-18 | 2019-06-18 | 国家计算机网络与信息安全管理中心 | The Host Supervision System of dynamically programmable |
| CN110515813A (en) * | 2019-08-15 | 2019-11-29 | 浙江万朋教育科技股份有限公司 | Oracle monitoring system and method based on shell script |
| CN111651307A (en) * | 2020-04-14 | 2020-09-11 | 北京中交兴路车联网科技有限公司 | Server health condition checking method, device, equipment and storage medium |
| CN115065616A (en) * | 2022-06-28 | 2022-09-16 | 平安银行股份有限公司 | Server monitoring method, server monitoring device and storage medium |
| CN115834696A (en) * | 2022-10-20 | 2023-03-21 | 北京新数科技有限公司 | Database performance monitoring platform data acquisition device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1547120A (en) * | 2003-12-10 | 2004-11-17 | 沈阳东软软件股份有限公司 | Network monitoring management system |
| CN101834750A (en) * | 2009-12-29 | 2010-09-15 | 山东中创软件商用中间件股份有限公司 | Method for monitoring communication service |
| CN101846985A (en) * | 2009-03-25 | 2010-09-29 | 鸿富锦精密工业（深圳）有限公司 | Remote data acquisition system and method |
| CN101854270A (en) * | 2010-04-23 | 2010-10-06 | 山东中创软件工程股份有限公司 | Multisystem running state monitoring method and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102156729A (en) * | 2011-03-29 | 2011-08-17 | 北京京东世纪贸易有限公司 | System and method for monitoring database servers |
-
2011
- 2011-03-29 CN CN2011100857887A patent/CN102156729A/en active Pending
-
2012
- 2012-03-09 WO PCT/CN2012/072144 patent/WO2012130030A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1547120A (en) * | 2003-12-10 | 2004-11-17 | 沈阳东软软件股份有限公司 | Network monitoring management system |
| CN101846985A (en) * | 2009-03-25 | 2010-09-29 | 鸿富锦精密工业（深圳）有限公司 | Remote data acquisition system and method |
| CN101834750A (en) * | 2009-12-29 | 2010-09-15 | 山东中创软件商用中间件股份有限公司 | Method for monitoring communication service |
| CN101854270A (en) * | 2010-04-23 | 2010-10-06 | 山东中创软件工程股份有限公司 | Multisystem running state monitoring method and system |
Cited By (35)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012130030A1 (en) * | 2011-03-29 | 2012-10-04 | 北京京东世纪贸易有限公司 | System and method for monitoring multiple database servers |
| CN102821003A (en) * | 2011-12-07 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and system for patrolling system resource performances |
| CN102521339A (en) * | 2011-12-08 | 2012-06-27 | 北京京东世纪贸易有限公司 | System and method for dynamic access of data sources |
| CN102521339B (en) * | 2011-12-08 | 2014-11-19 | 北京京东世纪贸易有限公司 | System and method for dynamic access of data sources |
| CN102565296A (en) * | 2011-12-11 | 2012-07-11 | 天津大学 | On-line early warning system and early warning method for quality of raw water of water reclamation plant |
| CN102521390A (en) * | 2011-12-21 | 2012-06-27 | 北京人大金仓信息技术股份有限公司 | Database management and monitoring system based on pin function |
| CN102567531A (en) * | 2011-12-30 | 2012-07-11 | 互动在线（北京）科技有限公司 | General method for monitoring status of light database |
| CN102567531B (en) * | 2011-12-30 | 2014-07-30 | 互动在线（北京）科技有限公司 | General method for monitoring status of light database |
| CN103186624A (en) * | 2011-12-31 | 2013-07-03 | 北京亿阳信通科技有限公司 | Data synchronization method and data synchronization device |
| CN103186624B (en) * | 2011-12-31 | 2017-10-20 | 亿阳信通股份有限公司 | A kind of method of data synchronization and data synchronization unit |
| CN103326958A (en) * | 2012-03-22 | 2013-09-25 | 鸿富锦精密工业（深圳）有限公司 | Method and system for monitoring data cache |
| CN102707026A (en) * | 2012-06-06 | 2012-10-03 | 天津大学 | Water reclamation plant raw water quality online early warning system and control method thereof |
| CN103546331A (en) * | 2012-07-16 | 2014-01-29 | 中兴通讯股份有限公司 | Method, device and system for acquiring monitoring information |
| CN103546331B (en) * | 2012-07-16 | 2018-10-26 | 南京中兴新软件有限责任公司 | Acquisition methods, the apparatus and system of monitoring information |
| CN102970183A (en) * | 2012-11-22 | 2013-03-13 | 浪潮(北京)电子信息产业有限公司 | Cloud monitoring system and data reflow method thereof |
| CN103107921B (en) * | 2013-02-01 | 2015-12-02 | 大唐移动通信设备有限公司 | Method for supervising and system |
| CN103888378B (en) * | 2014-04-09 | 2017-08-25 | 北京京东尚科信息技术有限公司 | A kind of data exchange system and method based on caching mechanism |
| CN103888378A (en) * | 2014-04-09 | 2014-06-25 | 北京京东尚科信息技术有限公司 | Data exchange system and method based on cache mechanism |
| CN104615660A (en) * | 2015-01-05 | 2015-05-13 | 浪潮(北京)电子信息产业有限公司 | Method and system for monitoring database performance |
| CN104954201A (en) * | 2015-06-19 | 2015-09-30 | 上海卓悠网络科技有限公司 | Sampling method and sampling device for heath data of network and servers of IDC (Internet Data Center) |
| CN105183608A (en) * | 2015-08-14 | 2015-12-23 | 广东能龙教育股份有限公司 | Monitoring and early warning method for multiple databases |
| CN105912443A (en) * | 2016-04-12 | 2016-08-31 | 乐视控股（北京）有限公司 | Method and system for acquiring user's customized monitoring index data |
| CN106059794A (en) * | 2016-05-13 | 2016-10-26 | 努比亚技术有限公司 | Monitoring method and monitoring apparatus |
| CN108667872A (en) * | 2017-03-31 | 2018-10-16 | 北京京东尚科信息技术有限公司 | Archiving method and device for dispatch server |
| CN108667872B (en) * | 2017-03-31 | 2021-04-30 | 北京京东尚科信息技术有限公司 | Archiving method and device for scheduling server |
| CN107241242A (en) * | 2017-07-19 | 2017-10-10 | 北京奇艺世纪科技有限公司 | A kind of data processing method and device |
| CN107454369A (en) * | 2017-08-23 | 2017-12-08 | 广东电网有限责任公司佛山供电局 | A kind of ultra-high-tension power transmission line intelligent video monitoring system and its method of work |
| CN108874626A (en) * | 2018-05-31 | 2018-11-23 | 泰康保险集团股份有限公司 | System monitoring method and apparatus |
| CN109408340A (en) * | 2018-11-06 | 2019-03-01 | 云宏信息科技股份有限公司 | Store monitoring method, the storage medium of equipment |
| CN109800136A (en) * | 2018-12-06 | 2019-05-24 | 珠海西山居移动游戏科技有限公司 | A kind of long-range redis performance data method of sampling and its system |
| CN109901971A (en) * | 2019-02-18 | 2019-06-18 | 国家计算机网络与信息安全管理中心 | The Host Supervision System of dynamically programmable |
| CN110515813A (en) * | 2019-08-15 | 2019-11-29 | 浙江万朋教育科技股份有限公司 | Oracle monitoring system and method based on shell script |
| CN111651307A (en) * | 2020-04-14 | 2020-09-11 | 北京中交兴路车联网科技有限公司 | Server health condition checking method, device, equipment and storage medium |
| CN115065616A (en) * | 2022-06-28 | 2022-09-16 | 平安银行股份有限公司 | Server monitoring method, server monitoring device and storage medium |
| CN115834696A (en) * | 2022-10-20 | 2023-03-21 | 北京新数科技有限公司 | Database performance monitoring platform data acquisition device |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2012130030A1 (en) | 2012-10-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102156729A (en) | System and method for monitoring database servers | |
| US20210184947A1 (en) | Automatic capture of detailed analysis information based on remote server analysis | |
| US8892719B2 (en) | Method and apparatus for monitoring network servers | |
| US9015316B2 (en) | Correlation of asynchronous business transactions | |
| CN102916839A (en) | Automatic monitoring system for agricultural work in sugarhouse | |
| CN104022902A (en) | Method and system of monitoring server cluster | |
| CN105373899A (en) | Server asset management method and apparatus | |
| CN111125444A (en) | Big data task scheduling management method, device, equipment and storage medium | |
| CN103488793A (en) | User behavior monitoring method based on information retrieval | |
| CN107919987B (en) | Method for realizing micro-service cloud deployment | |
| CN110046041B (en) | Data acquisition method based on battery scheduling framework | |
| CN102231673A (en) | System and method for monitoring business server | |
| CN112867989A (en) | Flow-based composition and monitoring server system and method | |
| CN102638378A (en) | Mass storage system monitoring method integrating heterogeneous storage devices | |
| CN106730833A (en) | A kind of network game service condition monitoring system and method | |
| CN110032497A (en) | A kind of monitoring system and method for achievement data | |
| WO2015192664A1 (en) | Device monitoring method and apparatus | |
| CN110968479A (en) | Business-level full-link monitoring method for application program and server | |
| CN109800133A (en) | A kind of method, one-stop monitoring alarm platform and the system of unified monitoring alarm | |
| CN110929130B (en) | Public security level audit data query method based on distributed scheduling | |
| US10353792B2 (en) | Data layering in a network management system | |
| CN111817865A (en) | Method for monitoring network management equipment and monitoring system | |
| CN202385116U (en) | Distributed operation and maintenance data acquisition device | |
| CN109525422A (en) | A kind of daily record data method for managing and monitoring | |
| CN107612723A (en) | A kind of system monitored in real time to being monitored equipment running status |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1157900 Country of ref document: HK |
|
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110817 |
|
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: WD Ref document number: 1157900 Country of ref document: HK |