Patent ID: 7694070
Filing Date: 2010-04-06
Classification: G06F

Abstract:
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.