Systems and methods for database active monitoring
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.
1. 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.
2. The method of claim 1 , wherein the database system comprises a Teradata database.
3. The method of claim 1 , wherein the session data is monitored for at least one of a blocked user session, a high CPU user session, a hung loads, a long running load, and a long running user session.
4. The method of claim 1 , wherein the session data comprises at least one of a blocked user session, a high CPU user session, a hung loads, a long running load, and a long running user session.
5. The method of claim 1 , further comprising:
receiving the at least one threshold from at least one of the session property files.
6. The method of claim 1 , wherein the system property file comprises data related to abort statements, blocking user sessions, blocking on a system table, system database free space, excessive delay for one of the user sessions, and the availability of storage for user queries.
7. The method of claim 1 , wherein the at least one threshold is set based on machine learning.
8. The method of claim 1 , further comprising:
the database monitor retrieving custom data to process the alert.
9. The method of claim 8 , wherein the alert comprises an identification of the breached threshold, an identification of the automated action taken, and an identification of a potential impact on the user session or database system.
10. The method of claim 1 , wherein the step of monitoring the plurality of user sessions is continuous.
11. 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.
12. The system of claim 11 , wherein the database system comprises a Teradata database.
13. The system of claim 11 , wherein the session data is monitored for at least one of a blocked user session, a high CPU user session, a hung loads, a long running load, and a long running user session.
14. The system of claim 11 , wherein the at least one threshold is received from at least one of the session property files, the at least one of the session property files comprises data related to at least one of a blocked user session, a high CPU user session, a hung loads, a long running load, and a long running user session.
15. The system of claim 11 , wherein at least one threshold related to the monitored database system is received from the system property file, the system property file comprises data related to abort statements, blocking user sessions, blocking on a system table, system database free space, excessive delay for one of the user sessions, and the availability of storage for user queries.