CV0-002 · Question #148
A company has purchased two new servers to host several virtualized database servers. Each server has two 3GHz quad-core processors each, 64GB RAM each, 200GB DAS, and two 10GbE NICs each. Which of th
The correct answer is D. NIC. For virtualized database servers, network I/O is a common bottleneck due to high transaction volumes and replication traffic, making the 10GbE NICs a likely limitation compared to other resources.
Question
A company has purchased two new servers to host several virtualized database servers. Each server has two 3GHz quad-core processors each, 64GB RAM each, 200GB DAS, and two 10GbE NICs each. Which of the following is the MOST likely bottleneck for these systems?
Options
- AProcessors
- BSAN
- CRAM
- DNIC
How the community answered
(16 responses)- A6% (1)
- B6% (1)
- C19% (3)
- D69% (11)
Why each option
For virtualized database servers, network I/O is a common bottleneck due to high transaction volumes and replication traffic, making the 10GbE NICs a likely limitation compared to other resources.
Two 3GHz quad-core processors provide 8 physical cores per server, which is generally sufficient for many virtualized database workloads unless extremely high concurrency is expected.
The question states '200GB DAS' (Direct Attached Storage), implying no SAN is currently in use, making it an irrelevant option for a bottleneck.
64GB of RAM per server is a substantial amount for many virtualized database server deployments and is unlikely to be the primary bottleneck, though specific database sizes and workloads could change this.
Database servers, especially virtualized ones, often generate significant network traffic due to client connections, inter-server communication, replication, and backup operations. While 10GbE NICs are fast, they can become a bottleneck when handling the aggregated network I/O of multiple demanding virtualized database instances, especially when compared to the ample CPU and RAM resources provided.
Concept tested: Identifying bottlenecks in virtualized database servers
Source: https://learn.microsoft.com/en-us/windows-server/administration/performance-tuning/subsystem/network-tuning
Topics
Community Discussion
No community discussion yet for this question.