Method and Apparatus for Monitoring an In-memory Computer System

• US 20150149400A1
• Filed: 04/02/2014
• Published: 05/28/2015
• Est. Priority Date: 04/18/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Werner, Marc-Philip, Auer, Wolfgang
• Granted Patent: US 9,389,982 B2
• Time in Patent Office: Days
• US Class Current: 707/600
• CPC Class Codes: G06F 11/3072 where the reporting involves data filtering, e.g. pattern matching, time or event triggered, adaptive or policy-based reporting
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 11/3452 Performance evaluation by statistical analysis
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

An in-memory computing system for conducting on-line transaction processing and on-line analytical processing includes system tables in main memory to store runtime information. A statistics services can access the runtime information using script procedures stored in the main memory to collect monitoring data and generate historical data and other system performance metrics while maintaining the runtime data and generated data in the main memory.

Claims

1. A method for monitoring system performance of an in-memory computer system comprising:

conducting, by the in-memory computer system, a plurality of on-line transaction processes (OLTPs) to receive and store data in a main memory component of the in-memory computer system;

conducting, by the in-memory computer system, a plurality of on-line analytical processes (OLAPs) on the data stored in the main memory component to produce a plurality of data analysis results;

storing, by the in-memory computer system, runtime information in a plurality of system tables in the main memory component relating to the step of conducting a plurality of OLTPs and the step of conducting a plurality of OLAPs; and

executing, by the in-memory computer system, a first script procedure, stored in the main memory, to copy some of the runtime information from one or more of the plurality of system tables to one or more of a plurality of statistics tables in the main memory as monitoring data.

2. The method of claim 1 further comprising executing, by the in-memory computer system, a second script procedure, stored in the main memory, to perform data analysis on the monitoring data in one or more of the plurality of statistics tables to generate a plurality of system performance metrics.

3. The method of claim 2 further comprising executing, by the in-memory computer system, the second script procedure to store the plurality of system performance metrics in one or more of the plurality of statistics tables.

4. The method of claim 2 wherein the first script procedure comprises the second script procedure.

5. The method of claim 1 further comprising executing, by the in-memory computer system, the first script procedure to evaluate the monitoring data according to one or more alert condition definitions, and to write an alert to one or more of a plurality of alert tables stored in the main memory when an alert condition is detected.

6. The method of claim 5 further comprising executing, by the in-memory computer system, the first script procedure to send an email initiation request in response to the writing of the alert to the one or more of the plurality of alert tables.

7. The method of claim 1 further comprising executing, by the in-memory computer system, a scheduler process in accordance with a predetermined configuration file to initiate the executing of the first script procedure.

8. The method of claim 1 wherein the first script procedure comprises a plurality of structured query language commands.

9. The method of claim 8 wherein the one of more of the plurality of structured query language commands comprises a logical operator to evaluate the monitoring data against one or more threshold values.

10. The method of claim 1 wherein the runtime information remains in the main memory as it is copied from the one or more of the plurality of system tables to the one or more of a plurality of statistics tables.

11. An in-memory computing system comprising:

a plurality of server subsystems;

a main memory subsystem in data communication with the plurality of server subsystems and having stored thereon one or more system tables, one or more script procedures, and one or more statistics tables;

a scheduler subsystem in data communication with the main memory subsystem;

a disk storage subsystem; and

computer executable instructions stored among the main memory subsystem and the disk storage subsystem,

wherein the computer executable instructions are configured to cause the server subsystems to;

execute a plurality of on-line transaction processes (OLTPs) to receive and store data in a memory component of the in-memory computer system;

execute a plurality of on-line analytical processes (OLAPs) on the data stored in the memory component to produce a plurality of data analysis results; and

store runtime information in a plurality of system tables in the main memory subsystem relating to the step of conducting a plurality of OLTPs and the step of conducting a plurality of OLAPs; and

wherein the computer executable instructions are configured to cause the scheduler subsystem to;

invoke a first script procedure of the one or more script procedures in the main memory subsystem to copy some of the runtime information from one or more of the plurality of system tables to one or more of the statistics tables in the main memory subsystem as monitoring data.

12. The system of claim 11 wherein the computer executable instructions are further configured to cause the scheduler subsystem to invoke a second script procedure of the one or more script procedures in the main memory subsystem to perform data analysis on the monitoring data in one or more of the statistics tables to generate a plurality of system performance metrics.

13. The system of claim 12 wherein the computer executable instructions are further configured to cause the scheduler subsystem to invoke the second script procedure to store the plurality of system performance metrics in one or more of the plurality of statistics tables.

14. The system of claim 11 wherein the computer executable instructions are further configured to cause the scheduler subsystem to invoke the first script procedure to evaluate the monitoring data in the main memory subsystem according to one or more alert condition definitions, and to write an alert to one or more of a plurality of alert tables in the main memory when an alert condition is detected.

15. The system of claim 11 wherein the runtime information remains in the main memory as it is copied from the systems tables to the statistics tables as monitoring data.

16. A non-transient computer readable medium having stored thereon computer executable instructions configured to cause one or more data processing units to perform steps of:

conducting a plurality of on-line transaction processes (OLTPs) to receive and store data in a main memory of the in-memory computer system;

conducting a plurality of on-line analytical processes (OLAPs) on the data stored in the memory component to produce a plurality of data analysis results;

storing runtime information in a plurality of system tables in the main memory relating to the step of conducting a plurality of OLTPs and the step of conducting a plurality of OLAPs; and

executing a script procedure in the main memory to copy some of the runtime information from one or more of the plurality of system tables to one or more statistics tables in the main memory as monitoring data.

17. The computer readable medium of claim 16 wherein the computer executable instructions are further configured to cause one or more data processing units to perform a step of executing a second script procedure in the main memory to perform data analysis on the monitoring data in one or more of the statistics tables to generate a plurality of system performance metrics.

18. The computer readable medium of claim 17 wherein the computer executable instructions are further configured to cause one or more data processing units to perform a step of executing the second script procedure to store the plurality of system performance metrics in one or more of the plurality of statistics tables.

19. The computer readable medium of claim 16 wherein the computer executable instructions are further configured to cause one or more data processing units to perform steps of:

executing the first script procedure to evaluate the monitoring data in the main memory according to one or more alert condition definitions, and

storing an alert condition message to one or more of the alert tables in the main memory when an alert condition is detected

20. The computer readable medium of claim 16 wherein the runtime information remains in the main memory as it is copied from the systems tables to the statistics tables as monitoring data.