HP ProLiant 3000 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Ser - Page 22

Page 20 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq Servers The following charts represent system processor scalability tested on the Compaq ProLiant 3000, 5500 and 6500 servers using the exact queries defined in the TPC-D benchmark. Across all servers, the best improvement came with additional and faster processors. Adding cache provided minimal improvement, depending upon the number of processors used. Figure 11 displays results from tests on the Compaq ProLiant 5500 and 6500 servers (both Pentium Pro processors), using 3G RAM and 512K cache. They display processor scalability for 1, 2 and 4 processors. Total Query Time (Hours) Total Query Time (Hours) ProLiant 6500/200MHz 512K Cache, 3G RAM 25 20 15 10 5 0 1 2 4 # Processors ProLiant 5500/200MHz 512K cache, 3G RAM 25 20 15 10 5 0 1 2 4 # Processors Figure 11: System Processor Scalability - # of Processors Figure 12 displays the comparison between query time on the Compaq ProLiant 5500 (Pentium Pro processor) and ProLiant 3000 (Pentium II processor), using 512M RAM and 512K cache. The Pentium Pro processor clock speed is 200MHz, and the Pentium II processor clock speed is 300MHz. The maximum RAM for the Pentium II processors is 512M. Each set of queries was run with 2 processors. Figure 12: Pentium Pro (200MHz) vs. Pentium II (300MHz) - TPCD Query Time (seconds) Query # 1 4 15 10 11 6 2 16 14 8 12 17 3 5 13 7 9 # Seconds (total) # Hours (total) Pentium Pro 15977.13 2419.27 417.69 2598.83 454.73 287.21 540.37 1450.92 579.38 3495.63 898.03 320.23 4468.03 6378.34 87.46 7249.83 18376.33 65999.41 18.33 Pentium II 9817.73 1748.42 275.9 2023.72 381.98 203.26 456.47 1101.16 428.99 2552.86 670.11 272.1 3472.14 5143.45 82.43 5837.44 18672.73 53140.89 14.76 © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398