Users report that a database server responds slowly or drops connections to other servers at random during busy times. A technician notices the database and servers are connected to an access switch in the office. Which of the following should the technician do to improve the performance of the database server?
The database server's connectivity and performance are likely being hampered by limitations of the access switch. Moving the server connection to the core switch can offer higher bandwidth, reduced congestion, and better overall performance. Core switches are designed to handle larger amounts of data traffic and offer more efficient data processing, which can help in mitigating issues of slow response times or dropped connections during busy periods. This would be a more effective solution than changing switch ports or using link aggregation on the access switch.
B should be correct
D. Move the server connection from the access switch to the core switch.
I don't normally like ChatGPT, but I actually think its response is helpful here to clarify: While implementing LACP could help distribute traffic more evenly across multiple links and provide redundancy, it may not fully address the performance issues experienced during busy times. Therefore, moving the server connection to the core switch (option D) is likely to be a more comprehensive solution in this scenario.
be is correct
As a Sr DBA, I would look at the database server and see if it needs CPU, Ram, Stats updated or indexes defragmented.... But that is outside of the scope of this test.