C4040-250 · Question #18
A customer has a 6TB database that needs a very high performance solution at the lowest cost. Which system is the more cost effective solution?
The correct answer is A. The S824 with attached FlashSystem 840. Huge OLTP workloads running on a database server would normally need a large amount of costly system memory (RAM) used for the database System Global Area (SGA) on the host server. The large SGA might help to keep more frequently accessed data and frequently executed SQL…
Question
A customer has a 6TB database that needs a very high performance solution at the lowest cost. Which system is the more cost effective solution?
Options
- AThe S824 with attached FlashSystem 840.
- BThe S824 with integrated SSDs and V5000.
- CAn E870 with internal disk drives and SSDs.
- DThe S824 with internal disk dnves and SSDs with Easy Tier.
How the community answered
(33 responses)- A73% (24)
- B15% (5)
- C3% (1)
- D9% (3)
Explanation
Huge OLTP workloads running on a database server would normally need a large amount of costly system memory (RAM) used for the database System Global Area (SGA) on the host server. The large SGA might help to keep more frequently accessed data and frequently executed SQL statements in the database buffer cache and libraries to avoid high latency I/O requests to the storage subsystem. IBM FlashSystem 840 is a solution for low latency I/O requests and thus helps reduce the size of the SGA. The fast access of data from IBM FlashSystem 840 minimizes the use of costly memory on the host servers for the applications
Topics
Community Discussion
No community discussion yet for this question.