Patent ID: 8341181

Claim:
A method for performance tuning a database running on a computing system, the computing system comprising at least one processor and a first random access memory, the database having data structures, attributes, and files, the method comprising: setting a database-allowed core value attribute between 500 megabytes and half size of the first random access memory for the database, the database-allowed core value representing the amount of the first random access memory which will be available to the database; allocating to the database a first portion of the first random access memory corresponding to the database-allowed core value; setting a memory resident limit value between 0 and the database-allowed core value for the database; declaring small and heavily accessed data structures within the database as memory resident structures and storing the small and heavily accessed structures within the first portion of the first random access memory up to the memory resident limit value; analyzing the database to determine whether read-ahead should be enabled for the data structures, the analysis comprising a review of a ratio of logical to physical read-I/O's used by the database; analyzing the database to determine an appropriate reblocking factor between 1 and 60, and applying the reblocking factor to the database; and associating system buffers ranging from 1000 to 20000 with the data structures, the system buffers being stored in the first portion of the first random access memory.