Database system monitoring method without connecting the database system
AssigneeWarevally Co., LTD.
InventorsJang Keon Ra, Bum Kim
Life of this patent
Estimating the term…
Abstract
This disclosure relates to methods for monitoring a database system without access to the database system, wherein when data packets between a plurality of operating servers including the database system and a plurality of client application processes are sent and/or received through a SQL net protocol or BEQ protocol, the data packets are collected through sniffing by a monitoring process or through a separate pipe gateway process thereby SQL information and database performance information transmitted between the operating servers and the client application processes are extracted. The SQL information and database performance information can be effectively monitored with no load or minimized load to the database, operating server and network.
Claims18
A method for monitoring a database system without access to the database system, the method comprising the steps of determining whether data packets between a plurality of operating servers including the database system and a plurality of client application processes are sent and/or received through a SQL net protocol, wherein if said data packets are sent and/or received through the SQL net protocol further comprising collecting said data packets through sniffing by a monitoring process thereby SQL information and database performance information transmitted between said operating servers and said client application processes are extracted.
A method for monitoring a database system without access to the database system, the method characterized in that when data packets between a plurality of operating servers including the database system and a plurality of client application processes are sent and/or received through a BEQ protocol, said data packets are collected by a separate pipe gateway process such that every SQL information and database performance information transmitted between said operating servers and said client application processes are extracted.
A method for monitoring a database system without access to the database system, the method characterized in that when data packets between a plurality of operating servers including the database system and a plurality of client application processes are sent and/or received through a SQL net protocol, said data packets are collected through sniffing by a monitoring process, thereby SQL information and database performance information transmitted between said operating servers and said client application processes are extracted, wherein said monitoring process comprises the steps of:
- determining whether a network adapter to be monitored is a loopback device;
- performing a sniffing mode if said network adapter is a loopback device;
- setting and performing the sniffing mode if said network adapter is not the loopback device;
- determining whether the program is to be terminated;
- determining whether the direction of the data packets is from said client application process to the operating server if the program is not to be terminated;
- extracting said SQL information if the direction of the packets is from the client application process to the operating server;
- and
- extracting said database performance information if the direction of the packets is not from the client application process to the operating server.
Dependencies are inferred from the claim text.