System and method for configuring a server computer for optimal performance for a particular server type
First Claim
1. In a client server environment where a server computer may be configured to act as any of a plurality of server types, and where the performance of the server computer when acting as any of the server types is determined by various server configuration parameters that can be adjusted to optimize operation for a given server type, a method for configuring the server computer including (1) automatically calculating configuration parameters that are optimized to the specific server types supported by the server computer to improve performance over using a default set of configuration parameters for all server types and (2) placing files used by the server computer on disks that will further increase overall server performance, the method comprising the steps of:
- querying an administrator for server data, comprising any of the number of users that are expected to be connected to the server, the number of users in the entire organization, the amount of memory specifically allocated for server use, and the particular server types that are to be supported by the server;
determining from said server data provided by the administrator and from hardware information obtained directly from the server various server configuration parameters that can be adjusted to optimize operation for the particular server types that are to be supported by the server by performing at least the steps of;
calculating a total number of database buffers to be used by at least one software component on the server; and
calculating a number of execution threads that can be simultaneously executed by at least one software component on the server;
testing the read and write performance of a plurality of disk drives in order to determine the disk drives that are best suited to store various files used by the server in supporting the server types designated by said administrator;
determining the capacities of the disk drives; and
assigning the server files to specific disk drives based on the results of the read and write performance testing, the storage capacities of the disk drives, and the amount of memory in the server.
2 Assignments
0 Petitions
Accused Products
Abstract
A technique for configuring a server computer using an optimizer program to achieve optimal performance of the server based on the server types supported by the server. Configuration may involve both calculating server configuration parameters and deciding where to place various files used by the server. In order to decide where to place files, the hardware and software characteristics of the server disk drives are analyzed, and a performance table is generated. The disk drive performance data is then input into a series of algorithms of varying complexity to determine the drives where database files should be stored. Information regarding server utilization, the number of host users and the number of users in the organization is received from an administrator. The administrator input is used to calculate configuration parameters. The optimizer program may automatically adjust a plurality of registry parameters, and may automatically move one or more database and log files to the appropriate disk drives. Alternately, the administrator may be prompted to authorize the changes. The optimizer program may also save the changed parameters and locations to a registry log file.
-
Citations
20 Claims
-
1. In a client server environment where a server computer may be configured to act as any of a plurality of server types, and where the performance of the server computer when acting as any of the server types is determined by various server configuration parameters that can be adjusted to optimize operation for a given server type, a method for configuring the server computer including (1) automatically calculating configuration parameters that are optimized to the specific server types supported by the server computer to improve performance over using a default set of configuration parameters for all server types and (2) placing files used by the server computer on disks that will further increase overall server performance, the method comprising the steps of:
-
querying an administrator for server data, comprising any of the number of users that are expected to be connected to the server, the number of users in the entire organization, the amount of memory specifically allocated for server use, and the particular server types that are to be supported by the server; determining from said server data provided by the administrator and from hardware information obtained directly from the server various server configuration parameters that can be adjusted to optimize operation for the particular server types that are to be supported by the server by performing at least the steps of; calculating a total number of database buffers to be used by at least one software component on the server; and calculating a number of execution threads that can be simultaneously executed by at least one software component on the server; testing the read and write performance of a plurality of disk drives in order to determine the disk drives that are best suited to store various files used by the server in supporting the server types designated by said administrator; determining the capacities of the disk drives; and assigning the server files to specific disk drives based on the results of the read and write performance testing, the storage capacities of the disk drives, and the amount of memory in the server. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. In a client server environment where a server computer may be configured to act as any of a plurality of server types, and where the performance of the server computer when acting as any of the server types is determined by various server configuration parameters that can he adjusted to optimize operation for a given server type, a computer program product for configuring the server computer including (1) automatically calculating configuration parameters that are optimized to the specific server types supported by the server computer and (2) placing files used by the server computer on disks that will further increase overall server performance comprising:
a computer readable medium having computer executable instructions embodied thereon comprising; means for querying an administrator for server data comprising any of the number of users that are expected to be connected to the server the number of users in the organization, the amount of memory allocated for server use and the particular server types that are to be supported by the server; means for determining from at least said server data provided by the administrator various server configuration parameters that can be adjusted to optimize operation for the particular server types that are to he supported by the server comprising; means for calculating a total number of database buffers to be used by at least one software component on the server; and means for calculating a number of execution threads that can be simultaneously executed by at least one software component on the server; means for testing the read and write performance of a plurality of disk drives in order to determine the disk drives that are best suited to store various files used by the server in supporting the server types designated by the administrator; means for determining the capacities the disk drives; and means for assigning the server files to specific disk drives based on the results of the read and write performance testing and storage capacities of the disk drives. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
Specification