Computer system for managing performances of storage apparatus and performance management method of the computer system

• US 7,694,070 B2
• Filed: 06/19/2006
• Issued: 04/06/2010
• Est. Priority Date: 03/31/2003
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Mogi, Kazuhiko, Nishikawa, Norifumi, Idei, Hideomi
• Primary Examiner(s): Bragdon; Reginald G
• Assistant Examiner(s): Ruiz; Aracelis
• Application Number:
  US11/454,935
• Publication Number:
  US 20060242356A1
• Time in Patent Office: 1,387 Days
• Field of Search: 711/100
• US Class Current: 711/112
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 11/3419 by assessing time
• 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/3485 for I/O devices
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 2201/81 Threshold
• CPC Class Codes: G06F 2201/815 Virtual
• CPC Class Codes: G06F 2201/88 Monitoring involving counting
• CPC Class Codes: G06F 2201/885 Monitoring specific for caches
• CPC Class Codes: G06F 2209/508 Monitor
• CPC Class Codes: G06F 9/5083 Techniques for rebalancing the load in a distributed system

Abstract

In a computer system with a DBMS running thereon, management of the performance of a storage apparatus is executed by using a performance indicator provided by a user job so as to simplify the management of the performance. For this reason, a management server employed in the computer system monitors an operating state of each system element, a response time onto a job and other information. A method for estimating a processing time is given to the management server, which issues a setting modification command based on an estimated processing time.

Claims

1. A computer system for managing performance of a storage apparatus, comprising:

a first computer for operating a database management system;

a second computer for executing a program issuing a request for a process to said database management system; and

said storage apparatus for storing data handled by said database management system;

said computer system further comprising;

an interconnection apparatus connecting among said first computer, said second computer, and said storage apparatus, and

a management apparatus connected to said first and second computer, said storage apparatus, and said interconnection apparatus,

wherein said interconnection apparatus virtualizes storage areas had by said storage apparatus, provides said storage areas to said first computer as virtual storage areas, and measures the number of accesses to said virtual storage areas from said first computer and the amount of data received and sent between said first computer and said storage apparatus, and

wherein said management apparatus acquires;

information on performance required for executing said program;

information on data in a database used in a process specified in said request issued by said program to said database management system;

mapping information of said data used in execution of said program, and acquired from said first computer and said storage apparatus;

measured information including the number of accesses to said virtual storage areas acquired by said interconnection apparatus, and the amount of data transferred via said virtual storage areas; and

utilization statistic information acquired by said storage apparatus; and

wherein said management apparatus further;

creates a plan to change settings of said storage apparatus to satisfy required performance for executing said program by using said information on performance, said information on data, and said measured information, and

issues a request for a setting change according to said plan to change settings to said storage apparatus.

2. A computer system for managing performance of a storage apparatus in accordance with claim 1, wherein said interconnection apparatus comprises a first interface section connected to said storage apparatus and a second interface section connected to said first computer, and measures said measured information at each port of said first and second interface section.

3. A computer system for managing performance of a storage apparatus in accordance with claim 2, wherein when creating said plan to change settings of said storage apparatus,

wherein said management apparatus judges whether or not a port of said interconnection apparatus is in an overloaded state, issues a request for reducing load of said port to said interconnection apparatus if said management apparatus judges said port of said interconnection apparatus is in said overloaded state, and

wherein said interconnection apparatus reduces said load of said port in accordance with said request from said management apparatus.

4. A computer system for managing performance of a storage apparatus in accordance with claim 1, wherein when creating said plan to change settings of said storage apparatus such as migrating data from one of plural storage areas had by said storage apparatus to another storage area, by using acquired said information on performance, said information on data, said mapping information, and said measured information,

wherein said management apparatus acquires information as to a correspondence relation between said plural storage areas had by said storage apparatus and said virtual storage areas, from said interconnection apparatus, specifies one of said virtual storage areas corresponding one of said storage areas unused as a destination of a data migration, as a free area and issues a request for setting said specified free area into a destination of a data migration, and

wherein said interconnection apparatus sets said one of virtual storage areas specified as said free area into a destination of a data migration in accordance with said request from said management apparatus.

5. A computer system for managing performance of a storage apparatus in accordance with claim 1, wherein said first and second computer are one and the same computer.

6. A computer system for managing performance of a storage apparatus in accordance with claim 1, wherein said first or second computer implements functions of collecting said information of said management apparatus, creating said plan to change settings of said storage apparatus, and issuing a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus.

7. A computer system for managing performance of a storage apparatus in accordance with claim 1, wherein said storage apparatus implements functions of collecting said information of said management apparatus, creating said plan to change settings of said storage apparatus, and issuing a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus.

8. A computer system for managing performance of a storage apparatus in accordance with claim 1, wherein said interconnection apparatus implements functions of collecting said information of said management apparatus, creating said plan to change settings of said storage apparatus, and issuing a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus.

9. A computer system for managing performance of a storage apparatus, comprising:

a first computer for operating a database management system;

a second computer for executing a program issuing a request for a process to said database management system; and

said storage apparatus for storing data handled by said database management system;

said computer system further comprising;

an interconnection apparatus connecting among said first computer, said second computer, and said storage apparatus, and

a management apparatus connected to said first and second computer, said storage apparatus, and said interconnection apparatus,

wherein said interconnection apparatus virtualizes storage areas had by said storage apparatus, provides said storage areas to said first computer as virtual storage areas and measures the number of accesses to said virtual storage areas from said first computer and the amount of data received and sent between said first computer and said storage apparatus,

wherein said management apparatus acquires;

information on performance required for executing said program,

information on data in a database used in a process specified in said request issued by said program to said database management system,

mapping information of said data used in execution of said program, and acquired from said first computer and said storage apparatus,

measured information including the number of accesses to said virtual storage areas acquired by said interconnection apparatus, and the amount of data transferred via said virtual storage areas, and

utilization statistic information acquired by said storage apparatus, and

wherein said management apparatus further;

judges whether or not there is a overloaded component among components of said storage apparatus by using said information on performance, said information on data, and said measured information,

specifies said overloaded component,

judges whether or not an overloaded state can be eliminated by using an alternative component for said overloaded component, and

creates a plan to change settings of said storage apparatus to satisfy required performance for executing said program, which uses said alternative component, and issues a request for a setting change according to said plan to change settings to said storage apparatus.

10. A computer system for managing performance of a storage apparatus in accordance with claim 9,

wherein when specifying said overloaded component among components of said storage apparatus, said management apparatus specifies a port in a interface section connected to said first computer among components of said storage apparatus as said overloaded component,

wherein when judging whether or not overloaded state can be eliminated by using an alternative component for said overloaded component, said management apparatus judges whether or not said overloaded state can be eliminated by changing using one of access paths connecting between the storage area connected to said port specified as said overloaded component and said first computer, into using other access path connecting between said storage area and said first computer, and creates a plan to change settings for eliminating said overloaded state by changing using said one of access paths into using said other path, if judging said overloaded state can be eliminated.

11. A computer system for managing performance of a storage apparatus in accordance with claim 9, wherein said management apparatus acquires information on a priority level of said program, judges whether or not said overloaded state can be eliminated by using an alternative component for said overloaded component, and creates a plan to change settings for eliminating said overloaded state by executing programs on basis of the highest priority level sequentially among said programs using said overloaded component, if judging said overloaded state can not be eliminated.

12. A computer system for managing performance of a storage apparatus in accordance with claim 9, wherein when acquiring said information on performance required for said program,

wherein said management apparatus acquires a processing execution time required for said program, a method for estimating a processing execution time, and the amount of data to said program as an input,

wherein said management apparatus creates a plan to change settings of said storage apparatus, which uses said alternative component, by using said processing execution time required for said program, said method for estimating said processing execution time, and the amount of data to said program as an input.

13. A computer system for managing performance of a storage apparatus in accordance with claim 9, wherein said storage apparatus has a port for connecting said storage apparatus to an external apparatus and has a priority access control function for limiting an amount of processing making accesses through said port, and

wherein said management apparatus judges whether or not said overloaded state can be eliminated by using said alternative component for said overloaded component, and creates a plan to change a set value of said amount of processing in said priority-access control function, if judging said overloaded state can not be eliminated.

14. A computer system for managing performance of a storage apparatus in accordance with claim 9, wherein said storage apparatus has a data cache area, manages said data cache area as several segmented areas, and has functions of dynamically allocating said segmented areas of said data cache area, removing said segmented areas of said data cache area, and changing the size of segmented areas of said data cache area, and

wherein when specifying said overloaded component, said management apparatus specifies a storage area of said storage apparatus among components of said storage apparatus as said overloaded component, and creates a plan to change settings of said storage apparatus such as allocating said segmented areas of said data cache area, removing said segmented areas of said data cache area, and changing the size of segmented areas of said data cache area.

15. A computer system for managing performance of a storage apparatus in accordance with claim 9, wherein said storage apparatus has at least two physical storage means, a function of presenting a logical storage area using storage areas of said physical storage means, and a physical storage location modification function of dynamically changing a relation associating said logical storage area with said storage areas of said physical storage means, and

wherein said management apparatus creates a plan to change settings of said storage apparatus such as changing said relation associating said logical storage area with said storage areas of said physical storage means.

16. A computer system for managing performance of a storage apparatus in accordance with claim 9, wherein when acquiring said information on performance required for executing said program, said management apparatus acquires information on a processing response time required for said program and information on an actually measured value of said processing response time on said program, and creates a plan to change settings of said storage apparatus such as using information on a processing response time required for said program and information on an actually measured value of said processing response time on said program.

17. A performance management method provided for a computer system having a first computer for operating a database management system, a second computer for executing a program issuing a request for a process to said database management system, and a storage apparatus for storing data handled by said database management system, said performance management method comprising:

virtualizing storage areas of said storage apparatus by an interconnection apparatus connecting said first computer, said second computer, and said storage apparatus, and providing said storage areas to said first computer as virtual storage areas;

measuring the number of accesses to said virtual storage areas from said first computer and the amount of data transferred between said first computer and said storage apparatus via said virtual storage areas;

acquiring information on performance required for executing said program by a management apparatus connected to said first and second computer, said storage apparatus and said interconnection apparatus, information on data in a database used in a process specified in said request issued by said program to said database management system, mapping information of said data used in execution of said program, and acquired from said first computer and said storage apparatus, measured information including the number of accesses to said virtual storage areas acquired by said interconnection apparatus, and the amount of data transferred via said virtual storage areas, and utilization statistic information acquired by said storage apparatus; and

creating a plan to change settings of said storage apparatus to satisfy required performance for executing said program by using said information on performance, said information on data, and said measured information, and issuing a request for a setting change according to said plan to change settings to said storage apparatus.

18. A performance management method according to claim 17, wherein said interconnection apparatus comprises a first interface section connected to said storage apparatus and a second interface section connected to said first computer, and implements a function for measuring said measured information at each port of said first and second interface section.

19. A performance management method according to claim 18,

wherein when creating said plan to change settings of said storage apparatus, said management apparatus performs steps of:

judging whether or not a port of said interconnection apparatus is in an overloaded state; and

issuing a request for reducing load of said port to said interconnection apparatus if said management apparatus judges said port of said interconnection apparatus is in said overloaded state, and

wherein said interconnection apparatus implements a function for reducing said load of said port in accordance with said request from said management apparatus.

20. A performance management method according to claim 17,

wherein when creating said plan to change settings of said storage apparatus such as migrating data from one of plural storage areas had by said storage apparatus to another storage area, by using acquired said information on performance, said information on data, said mapping information, and said measured information, said management apparatus performs steps of:

acquiring information as to a correspondence relation between said plural storage areas had by said storage apparatus and said virtual storage areas from said interconnection apparatus;

specifying one of said virtual storage areas corresponding one of said storage areas unused as a destination of a data migration, as a free area; and

issuing a request for setting said specified free area into a destination of a data migration, and

wherein said interconnection apparatus implements a function for setting said one of virtual storage areas specified as said free area into a destination of a data migration in accordance with said request from said management apparatus.

21. A performance management method according to claim 17, wherein said first and second computer are one and the same computer.

22. A performance management method according to claim 17, wherein said first or second computer performs steps of collecting said information of said management apparatus, creating said plan to change settings of said storage apparatus, and issuing a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus.

23. A performance management method according to claim 17, wherein said storage apparatus performs steps of collecting said information of said management apparatus, creating said plan to change settings of said storage apparatus, and issuing a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus.

24. A performance management method according to claim 17, wherein said interconnection apparatus performs steps of collecting said information of said management apparatus, creating said plan to change settings of said storage apparatus, and issuing a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus.

25. A performance management method provided for a computer system having a first computer for operating a database management system, a second computer for executing a program issuing a request for a process to said database management system and a storage apparatus for storing data handled by said database management system, said performance management method comprising:

a procedure for acquiring information on performance required for executing said program;

a procedure for acquiring information on data in a database used in a process specified in said request issued by said program to said database management system;

a procedure for acquiring mapping information of data used for executing said program from said first computer and said storage apparatus;

a procedure for acquiring utilization statistic information from said storage apparatus;

a procedure for creating a plan to change settings of said storage apparatus to satisfy required performance for executing said program by using said information acquired by said procedures; and

a procedure for issuing a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus,

wherein said procedure includes a process for acquiring information on a processing response time required for said program and information on an actually measured value of said processing response time on said program, and

wherein said procedure uses said information on a processing response time required for said program and said information on an actually measured value of said processing response time on said program in creating said plan to change settings of said storage apparatus.

26. A computer system for managing performance of a storage apparatus, said computer system comprising:

a first computer for operating a database management system;

a second computer for executing a program issuing a request for a process to said database management system;

said storage apparatus for storing data handled by said database management system; and

a management apparatus,

wherein said management apparatus acquires;

information on performance required for executing said program,

information on data in a database data used in a process specified in said request issued by said program to said database management system,

mapping information of said data used in execution of said program from said first computer and said storage apparatus, and

utilization statistic information from said storage apparatus; and

wherein said management information further;

creates a plan to change settings of said storage apparatus to satisfy required performance for executing said program by using said acquired information; and

issues a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus,

wherein said acquiring information on performance includes a process for acquiring information on a processing response time required for said program and information on an actually measured value of said processing response time on said program.

27. A management apparatus for managing performance of a computer system having a first computer for operating a database management system, a second computer for executing a program issuing a request for a process to said database management system and a storage apparatus for storing data handled by said database management system,

wherein said management apparatus acquires:

information on performance required for executing said program,

information on data in a database used in a process specified in said request issued by said program to said database management system,

mapping information of said data used in execution of said program from said first computer and said storage apparatus, and

utilization statistic information from said storage apparatus; and

wherein said management apparatus further;

creates a plan to change settings of said storage apparatus to satisfy required performance for executing said program by using said acquired information; and

issues a request for changing settings in accordance with said plan to change settings of said storage apparatus to said storage apparatus,

wherein said acquiring of information on performance includes a process for acquiring information on a processing response time required for said program, and information on an actually measured value of said processing response time on said program.

28. A performance management method provided for a computer system having a first computer for operating a database management system, a second computer for executing a software program issuing a request for a process to said database management system, a storage apparatus for storing data handled by said database management system, and a storage control apparatus connected between said first computer and said storage apparatus and used for controlling data transfers between said first computer and said storage apparatus, said performance management method comprising:

collecting information from said computer system;

using said collected information to create a plan to change settings of said storage apparatus to satisfy required performance for executing said software program; and

issuing a request for changing the settings in accordance with said plan to change the settings of said storage apparatus to said storage apparatus by executing steps comprising;

acquiring information on performance required for executing said software program;

acquiring information on data of a database used in a process specified in said request issued by said software program to said database management system;

acquiring mapping information of said data used in execution of said software program from said first computer and said storage apparatus; and

acquiring utilization statistic information from said storage apparatus,

wherein said step of acquiring information includes acquiring information on a processing response time required for said software program and information on an actually measured value of said processing response time on said software program.