Sizing servers for database management systems via user defined workloads
US6957209B1 · kind B1 · utility
Assignee
Inventor
Key dates
| Filing date | Feb 29, 2000 |
| Grant date | Oct 18, 2005 |
| Priority date | — |
| Expiry date | Feb 29, 2020 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/217
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods for determining database management system server hardware requirements as a function of user-supplied transactions per second requirements, maximum processor utilization, and server type. Methods are also provided for determining workload requirements as a function of the expected transaction composition of the system including the expected transaction execution rate in transactions per second and the percent of total workload contribution by each statement. In one method, each transaction is further specified as a set of SQL statements each having a parameter list, where the workload contribution of each SQL statement is calculated as a function of the SQL statement parameter list.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.