Systems and methods for database active monitoring
AssigneeJPMorgan Chase Bank, N.A.
InventorsPrakash Konkimalla, Christopher Medved
Life of this patent
Estimating the term…
Abstract
System and methods for database active monitoring are disclosed. In one embodiment, in an information processing device comprising at least one computer processor, a method for database activity monitoring may include: (1) a database monitor monitoring data from a database system and a user session with the database system; (2) the database monitor comparing the monitored data to at least one threshold; (3) the database monitor executing an automated action in response to the monitored data breaching one of the thresholds; and (4) the database monitor initiating an alert based on the breached threshold.
Claims15
A method for database activity monitoring, comprising:
- in an information processing device comprising at least one computer processor:
- a database monitor monitoring a plurality of user sessions associated with a database system, wherein the database system is monitored for abort statements, blocking user sessions, blocking on a system table, system database free space, excessive delay for one of the user session, and an availability of storage for user queries;
- the database monitor accessing both a system property file of the database system and a session property file for each user session, the session property file comprising session data for each corresponding user session;
- the database monitor comparing the session data to at least one threshold, wherein the at least one threshold is based on the session property file;
- the database monitor executing an automated action for one of the user sessions in response to the session data breaching one of the thresholds, wherein the automated action comprises aborting one of the user sessions;
- and
- the database monitor initiating an alert based on the breached threshold, wherein the alert comprises an identifier of the breached threshold, an identifier of the automated action, and an impact indicator of the user session or database system.
A system for database activity monitoring, comprising:
- a database system having a user session therewith;
- and
- a database monitor comprising at least one computer processor;
- wherein:
- the database monitor monitors a plurality of user sessions associated the database system, wherein the database system is monitored for abort statements, blocking user sessions, blocking on a system table, system database free space, excessive delay for one of the user session, and an availability of storage for user queries;
- the database monitor accesses both a system property file of the database system and a session property file for each user session, the session property file comprising session data for each corresponding user session;
- the database monitor compares the session data to at least one threshold, wherein the at least one threshold is based on the session property file;
- the database monitor executes an automated action for one of the user sessions in response to the session data breaching one of the thresholds, wherein the automated action comprises aborting one of the user session;
- and
- the database monitor initiates an alert based on the breached threshold, wherein the alert comprises an identifier of the breached threshold, an identifier of the automated action, and an impact indicator of the user session or database system.
Dependencies are inferred from the claim text.