Method and Apparatus for Monitoring an In-memory Computer System

An apparatus comprising an in-memory computing system, the 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 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 plurality of server subsystems to:
• execute a plurality of on-line transaction processes (OLTPs), wherein executing the plurality of OLTPs includes:
• receiving runtime data, and
• storing the runtime data in a main 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, wherein executing the plurality of OLAPs produces a plurality of runtime data analysis results;
• and
• store the runtime data in a plurality of system tables in the main memory component;
• wherein the computer executable instructions are configured to cause the scheduler subsystem to:
• execute a statistics scheduler process;
• and
• perform the runtime data collection processes and the runtime data analysis processes in accordance with the statistics scheduler process, wherein performing the runtime data collection processes and the runtime data analysis processes includes copying 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.

A non-transitory computer readable storage medium having stored thereon computer executable instructions that, when executed, cause one or more data processing units of an in-memory computer system to perform a method comprising:

• executing, by the in-memory computer system, a plurality of on-line transaction processes (OLTPs), wherein executing the plurality of OLTPs includes:
• receiving runtime data, and
• storing the runtime data in a main memory component of the in-memory computer system for runtime data collection processes;
• executing, by the in-memory computer system, a plurality of on-line analytical processes (OLAPs) on the same runtime data for runtime data analysis processes, wherein executing the plurality of OLAPs produces 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;
• executing, by the in-memory computer system, a statistics scheduler process;
• and
• performing, by the in-memory computer system, the runtime data collection processes and the runtime data analysis processes in accordance with the statistics scheduler process, wherein performing the runtime data collection processes and the runtime data analysis processes includes copying 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.