Method and apparatus for monitoring an in-memory computer system

• US 9,389,982 B2
• Filed: 04/02/2014
• Issued: 07/12/2016
• Est. Priority Date: 04/18/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Werner, Marc-Philip, Auer, Wolfgang
• Primary Examiner(s): Reyes, Mariela
• Assistant Examiner(s): Vu, Thong
• Application Number:
  US14/243,567
• Publication Number:
  US 20150149400A1
• Time in Patent Office: 832 Days
• Field of Search: 707/600, 707/749, 707/736, 707/748, 707/602, 707/634
• US Class Current: 1/1
• 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 runtime data in a main memory component of the in-memory computer system for runtime data collection processes;

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

storing, by the in-memory computer system, the runtime data in a plurality of system tables in the main memory component

scheduling a first script procedure stored in the main memory to execute in the main memory component using a statistics scheduler process; and

executing, by the in-memory computer system, the first script procedure to perform the runtime data collection processes and the runtime data analysis processes and to copy at least some of the runtime data 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, a second 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 second 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 5 wherein the first script procedure is separate from the second script procedure.

8. The method of claim 5 wherein the first script procedure is adapted to be edited independently of the second script procedure, thereby enabling users to change the runtime data collection processes without altering alert determination processes, and enabling users to change the alert determination processes without altering the runtime data collection processes.

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

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

11. The method of claim 10 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.

12. 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.

13. 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 runtime data in a memory component of the in-memory computer system for runtime data collection processes;

execute a plurality of on-line analytical processes (OLAPs) on the same runtime data for runtime data analysis processes to produce a plurality of runtime data analysis results; and

store the runtime data in a plurality of system tables in the main memory subsystem,

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

schedule a first script procedure stored in the main memory to execute in the main memory component; and

invoke the first script procedure of the one or more script procedures in the main memory subsystem to perform the runtime data collection processes and the runtime data analysis processes and to copy at least some of the runtime data 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.

14. The system of claim 13 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.

15. The system of claim 14 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.

16. The system of claim 13 wherein the computer executable instructions are further configured to cause the scheduler subsystem to invoke a second 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.

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

18. A non-transient computer readable storage 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 runtime data in a main memory of the in-memory computer system for runtime data collection processes;

conducting a plurality of on-line analytical processes (OLAPs) on the same runtime data for runtime data analysis processes to produce a plurality of runtime data analysis results;

storing the runtime data in a plurality of system tables in the main memory;

scheduling a first script procedure stored in the main memory to execute in the main memory component using a statistics scheduler process; and

executing the first script procedure in the main memory to perform the runtime data collection processes and the runtime data analysis processes and to copy at least some of the runtime data from one or more of the plurality of system tables to one or more statistics tables in the main memory as monitoring data.

19. The computer readable medium of claim 18 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.

20. The computer readable medium of claim 19 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.

21. The computer readable medium of claim 18 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.

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