Unlock Hitachi VSP 5500 superior performance with Hitachi DS7000 Series server and Intel Optane Persistent Memory

By Libo Jiang posted 11-30-2020 15:02

Like

Leveraging the best of our Hitachi Solutions for Databases to improve your overall Oracle RAC performance and availability
Hitachi VSP 5500 is the king of performance & scale in today's data storage industry. And for many of our customer, a vital component for high performance Oracle database environment. There are multiple ways to construct a large-scale high-performance Oracle RAC database, including with possibly fewer and more powerful compute nodes, or a larger number of less powerful compute nodes. With fewer compute nodes, it is often less communication overhead among Oracle RAC nodes. Such an environment is also more flexible for batch jobs, BI/DW, backup & recovery processes etc.

Hitachi Advanced Server 7000 series has a unique modular architecture with several complementary models, each based on the Intel Xeon scalable processor. it's high reliability, extreme performance, and agile scalability make huge difference for high performance Oracle databases. You can upgrade a model to the next model, preserving your hardware and software investment as you grow.

This solution utilizes the new Optane DIMMs, code-named Apache Pass (AEP) and officially branded as Intel Optane DC Persistent Memory (DCPMM).

A new Oracle database solution we recently released, “Hitachi Solution for Databases Using Oracle 19c Database with Hitachi Virtual Storage Platform 5500 and Hitachi Advanced Server DS7000 series”, uses all three major components described above in a full Gen6 fabric environment.
With an 2 node VSP 5500 array, 4-socket DS7040 server and 24 Intel DCPMM DIMMs, we’re able to achieve 1.7M+ IOPS with a typical 70/30 OLTP workload. The table below shows the key results of testing this architecture with and without Intel’s AEP DIMMs. For more results, please review results below or click here for full RA.
TABLE 1. ORION TEST RESULTS

Test Category	Test Case	Test Results
		With 48 x 64GB DRAM DIMMs		With 24 x 64GB DRAM DIMMs and 16 x 256GB AEP DIMMs
		Throughput	RT (ms)	Throughput	RT (ms)
ORION	8KB Random Read	1,561,006 IOPS	0.83	N/A	N/A
	8KB Random Write	604,840 IOPS	0.81	N/A	N/A
	1MB Sequential Read	26.84 GB/s	N/A	N/A	N/A
	1MB Sequential Write	16.65 GB/s	N/A	N/A	N/A

TABLE 2. PEAKMARKS TEST RESULTS

Test Category	Test Case	Test Results
		With 48 x 64GB DRAM DIMMs		With 24 x 64GB DRAM DIMMs and 16 x 256GB AEP DIMMs
		Throughput	RT (ms)	Throughput	RT (ms)
peakmarks	STO-READ	24.91 GB/s	3.90	23.79 GB/s	7.28
	STO-Random 100% read	1,238,452 IOPS	0.96	1,252,623	0.95
	STO-Random 80% read/20% write	1,363,887IOPS	0.87	1,539,557	0.98
	STO-Random 70% read/30% write	1,561,952 IOPS	1.11	1,701,044	0.92
	STO-Random 100% write	891,794 IOPS	0.38	984,657	0.73
	SRV-SCAN	113.04 GB/s	N/A	133.51 GB/s	N/A
	DBWR-THR	5.55 GB/s	N/A	4.98 GB/s	N/A
	DA-LOW/ROW	109.69 GB/s	N/A	134.80 GB/s	N/A
	DA-LOW/STO	30.89 GB/s	N/A	31.02 GB/s	N/A
	DA-LOW/COL	1,645.95 GB/s	N/A	1,673.64 GB/s	N/A
	TP-LIGHT 1 RPT 0% update	420,548 tps	0.26	308,917 tps	0.41
	TP-LIGHT 1 RPT 20% update	277,695 tps	1.00	268,607 tps	0.62
	TP-LIGHT 1 RPT 30% update	280,288 tps	0.99	295,659 tps	0.75
	TP-MEDIUM 25 RPT 0% update	66,874 tps	4.15	21,567 tps	5.13
	TP-MEDIUM 25 RPT 20% update	14,729 tps	11.35	12,159 tps	8.36
	TP-MEDIUM 25 RPT 30% update	13,818 tps	8.07	11,818 tps	8.19

#Blog
#ThoughtLeadership
#FlashStorage

2 comments

9 views

Permalink

Comments

Chayan Sarkar

05-02-2022 02:11

Excellent

Dipta Kundu

04-25-2022 08:30

Great Write-up

Flash Storage​