System monitoring method

• US 7,512,680 B2
• Filed: 06/21/2004
• Issued: 03/31/2009
• Est. Priority Date: 03/08/2004
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Mogi, Kazuhiko, Nishikawa, Norifumi
• Primary Examiner(s): Etienne; Ario
• Assistant Examiner(s): GEORGANDELLIS, ANDREW C
• Application Number:
  US10/871,814
• Publication Number:
  US 20050198298A1
• Time in Patent Office: 1,744 Days
• Field of Search: 709/223, 709/224, 709/225, 709/226, 709/221, 710/56, 711/137, 714/38
• US Class Current: 709/224
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 11/3433 for load management allocation of a server based on load conditions G06F9/505; load rebalancing G06F9/5083; redistributing the load in a network by a load balancer H04L67/1029
• CPC Class Codes: G06F 11/3495 for systems
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/87 Monitoring of transactions
• CPC Class Codes: G06F 2201/885 Monitoring specific for caches

Abstract

A second computer for monitoring a database management system and a storage subsystem introduced into a first computer, is provided with a step of acquiring profile information of an application, a step of determining a tuning item in accordance with the acquired profile information, and a step of transferring the determined tuning item to the first computer and the storage subsystem.

Claims

1. A system comprising:

a computer system; and

a second computer connected to said computer system,

wherein said computer system comprises;

a first computer connected to said second computer; and

a storage subsystem connected to said second computer,

wherein said second computer comprises;

a first table, which includes a first record corresponding to each type of program to be executed on said computer system, each first record including an identifier of the program to be executed, and a tuning item of a resource to be tuned, corresponding to the program to be executed;

a second table, which includes a second record corresponding to each said type of program to be executed, each second record including an identifier of the program to be executed, and a profile of the program to be executed; and

a third table, which includes a third record corresponding to each tuning item, each third record including an identifier corresponding to the tuning item, and an indicator of a performance monitoring item that indicates what performance of said computer system is monitored when the tuning item is controlled and at what interval the performance is monitored or not monitored,

wherein said storage subsystem comprises a processor,

wherein said first computer notifies said second computer of the type of program to be executed on said computer system,

wherein said second computer acquires the tuning item corresponding to the type of program to be executed from the first table, acquires the profile of the program to be executed from the second table, and identifies a first performance monitoring item based on the type of the program to be executed from the third table, and issues to said computer system a notice to collect first performance information regarding said first performance monitoring item, and

wherein said computer system collects said first performance information in accordance with said notice to collect said first performance information.

2. The system according to claim 1, wherein said computer system notifies said second computer that said first performance information has been collected,

wherein said second computer transmits an instruction to change settings of said computer system to a predetermined value, if said first performance information does not satisfy a predetermined condition, and

wherein said computer system changes the settings in accordance with said instruction.

3. The system according to claim 2,

wherein said computer system notifies said second computer of a type of a program to be terminated at said computer system,

wherein said second computer identifies a second performance monitoring item in accordance with the type of the program to be terminated, and issues to said computer system an instruction to terminate a collection of second performance information regarding said second performance monitoring item, and

wherein said computer system terminates the collection of said second performance information in accordance with the instruction to terminate said collection of second performance information.

4. The system according to claim 3,

wherein said notice of the collection of said first performance information contains information regarding an interval at which said computer system collects said first performance information, and

wherein said computer system collects said first performance information at said interval, based on said information regarding the interval.

5. The system according to claim 4, wherein said second computer identifies each performance monitoring item to be monitored by said first computer and said storage subsystem, based on the type of the program to be executed at said computer system, and notifies said first computer and said storage subsystem of the collection of performance information regarding each performance monitoring item.

6. The system according to claim 5, wherein said second computer identifies said performance monitoring item in accordance with a program profile of the program to be executed at said computer system.

7. The system according to claim 6, wherein said program profile includes input/output characteristics from said first computer to said storage subsystem based on the program to be executed at said computer system.

8. The system according to claim 7, wherein said input/output characteristics include a sequential access and a random access.

9. The system according to claim 8, wherein said performance monitoring item includes an item of a use factor of the processor of said storage subsystem.

10. The system according to claim 9, wherein said computer executes a database management system, and said performance monitoring item includes a use factor of a memory of said computer by said database management system.

11. The system according to claim 10, wherein said predetermined condition is a condition that the use factor of the processor of said storage subsystem does not exceed a predetermined ratio.

12. A computer connected to a computer system, comprising:

a processor;

a storage unit; and

an interface that connects the computer to said computer system,

wherein said storage unit stores;

a first table, which includes a first record corresponding to each type of program to be executed by said processor, each first record including an identifier of the program to be executed, and a tuning item of a resource to be tuned, corresponding to the program to be executed;

a second table, which includes a second record corresponding to each said type of program to be executed, each second record including an identifier of the program to be executed, and a profile of the program to be executed; and

a third table, which includes a third record corresponding to each tuning item, each third record including an identifier corresponding to the tuning item, and an indicator of a performance monitoring item that indicates what performance of said computer system is monitored when the tuning item is controlled and at what interval the performance is monitored or not monitored,

wherein said computer system notifies said computer of the type of program to be executed by said processor, and

wherein based on the type of program to be executed, said processor acquires the tuning item corresponding to the type of program to be executed from the first table, acquires the profile of the program to be executed from the second table, and identifies said performance monitoring item corresponding to said program to be executed from the third table, and instructs said computer system to collect information regarding said identified performance monitoring item via said interface.

13. The computer according to claim 12, wherein first information contains second information representative of a relation between said program and the profile of said program, and third information representative of a relation between the profile of said program and said performance monitoring item.

14. The computer according to claim 13,

wherein said storage unit further stores fourth information regarding a change in settings of said computer system,

wherein said fourth information is used when said performance information does not satisfy a predetermined condition, and

wherein said processor instructs said computer system to change the settings based on the performance information and the fourth information.

15. A computer system connected to a first computer, comprising:

a second computer connected to said first computer via a network; and

a storage subsystem connected to said first computer via a network,

wherein said first computer comprises;

a first table, which includes a first record corresponding to each type of program to be executed on said second computer, each first record including an identifier of the program to be executed, and a tuning item of a resource to be tuned, corresponding to the program to be executed;

a second table, which includes a second record corresponding to each said type of program to be executed, each second record including an identifier of the program to be executed, and a profile of the program to be executed; and

a third table, which includes a third record corresponding to each tuning item, each third record including an identifier corresponding to the tuning item, and an indicator of a performance monitoring item that indicates what performance of said computer system is monitored when the tuning item is controlled and at what interval the performance is monitored or not monitored,

wherein said storage subsystem comprises a processor,

wherein said second computer notifies said first computer of the type of program to be executed on said second computer,

wherein said first computer acquires the tuning item corresponding to the type of program to be executed from the first table, acquires the profile of the program to be executed from the second table, acquires the performance monitoring item and the interval based on the type of program to be executed, from the third table, and provides information regarding acquires the tuning item corresponding to the type of program to be executed from the first table, acquires the profile of the program to be executed from the second table, and the performance monitoring item and the interval to said second computer, and

wherein based on said type of the program to be executed, said second computer and said storage subsystem collect said information of said performance monitoring item at said interval, and notify said first computer of said information collected regarding said performance monitoring item.

16. The computer system according to claim 15,

wherein said second computer and said storage subsystem receive from said first computer a notice of instructing a change in settings from said first computer, and

wherein said second computer and said storage subsystem change the settings in accordance with said notice.

17. A system comprising:

a computer system; and

a second computer connected to said computer system,

wherein said computer system comprises;

a first computer; and

a storage subsystem, wherein said first computer executes a database management system, and comprises;

a first processor; and

a storage unit,

wherein the storage unit stores;

a first table, which includes a first record corresponding to each type of program to be executed on said computer system, each first record including an identifier of the program to be executed, and a tuning item of a resource to be tuned, corresponding to the program to be executed;

a second table, which includes a second record corresponding to each said type of program to be executed, each second record including an identifier of the program to be executed, and a profile of the program to be executed; and

a third table, which includes a third record corresponding to each tuning item, each third record including an identifier corresponding to the tuning item, and an indicator of a performance monitoring item that indicates what performance of said computer system is monitored when the tuning item is controlled and at what interval the performance is monitored or not monitored,

wherein said storage subsystem comprises a second processor,

wherein said first computer notifies said second computer of a type of the program to be executed at said computer system,

wherein said second computer acquires the tuning item corresponding to the type of program to be executed from the first table, acquires the profile of said program based on the type of said program to be executed from the second table, acquires a performance monitoring item from said profile, based on the type of the program to be executed, from the third table, and issues a notice of a collection and a collection interval of information regarding said performance monitoring item, to said first computer and said storage subsystem of said computer system,

wherein said first computer and said storage subsystem of said computer system collects said performance information at said interval in accordance with said notice, and notifies said second computer of said performance information collected,

wherein said second computer transmits an instruction to change settings of said computer system to a predetermined value to said computer system, and

wherein said computer system changes the settings in accordance with said instruction.