Home > Workload Solutions > Oracle > White Papers > Accelerate Oracle Databases and Maximize Your Investment > Scenario 3: Larger databases and greater consolidation
The Dell PowerEdge R940 is a four-socket server solution designed for some of the largest databases and very large consolidation efforts. Memory is another key consideration in moving forward with the R940 as the server supports up to 48 DIMMs of which 24 can be Intel Optane persistent for a maximum configuration of 15.36 TB. This server offers a wide range of CPUs to match most any large database workload. In table 4, two CPUs are reviewed to provide a look into how this server could be configured.
Intel Xeon | Platinum 8280L | Platinum 8270 |
Total cores | 28 | 26 |
Total threads | 56 | 52 |
Base frequency | 2.7 GHz | 2.7 GHz |
Maximum turbo frequency | 4.0 GHz | 4.0 GHz |
Cache | 38.5 MB | 35.75 MB |
Both the Intel Xeon Platinum 8280L and the 8270 are very similar in base and max processor frequencies. However, the max frequency of these CPUs is higher than any reviewed in this paper. With a max frequency of 4.0 GHz these processors can significantly accelerate the completion of database jobs during peak workloads. The PowerEdge R940 with all four sockets populated with the Platinum 8280L processors provides the business with 112 physical processors and 224 virtual processors. This is the largest processor configuration reviewed.
The 8270 has 26 processors per CPU. With four of these CPUs the R940 will have 104 physical processors and 208 virtual processors. Both these CPU configurations maximize the ability to processor hundreds of instructions per cycle. For large enterprise databases this is the capability to support thousands of application users in the business. And to accelerate the completion of reports critical to the business.
The balance of memory and processor configurations also means the R940 can be a big consolidation platform for databases. This provides the business the means to significantly reduce the number of legacy servers and consolidate Oracle databases to a few R940 servers, depending on the scale of consolidation. For example, 20 virtualized databases each with 300 GB of memory and 10 vCPU could be consolidated to the R940 using both Intel processors and still have extra processing power. This is just one example of the possibilities, and every customer consolidation effort will be different.
Consider the Dell PowerEdge R940 for large databases and consolidation programs as this server provides massive processing power and flexibility in design to meet most demanding workloads. To learn more about R940 performance, visit the server page.