SK0-004 · Question #844
An administrator is sizing a new server for a 500GB database application. Which of the following components on the server will provide the BEST performance?
The correct answer is C. RAM. For a 500GB database application, RAM provides the best performance by allowing the database engine to cache large data sets in memory, dramatically reducing disk I/O.
Question
An administrator is sizing a new server for a 500GB database application. Which of the following components on the server will provide the BEST performance?
Options
- ADisk
- BProcessor
- CRAM
- DNetwork card
How the community answered
(54 responses)- A6% (3)
- B9% (5)
- C83% (45)
- D2% (1)
Why each option
For a 500GB database application, RAM provides the best performance by allowing the database engine to cache large data sets in memory, dramatically reducing disk I/O.
Disk speed affects read/write throughput, but RAM caching reduces disk access frequency so dramatically that disk alone is not the best single performance lever.
The processor handles query execution and sorting, but database workloads are typically memory-bound before they are CPU-bound.
Database engines use RAM to cache table data, indexes, and query results, minimizing slow disk reads. With a 500GB database, maximizing RAM allows more of the working data set to reside in memory, which is orders of magnitude faster than any storage medium. RAM is consistently the most impactful hardware component for database server performance tuning.
The network card affects data transfer speed to clients but is rarely the bottleneck for a server-side database application.
Concept tested: RAM sizing for database server performance
Source: https://learn.microsoft.com/en-us/sql/relational-databases/memory-management-architecture-guide
Topics
Community Discussion
No community discussion yet for this question.