nerdexam
CompTIA

SK0-005 · Question #597

A user reports that a database is slow. The RAM utilization on the server recently jumped to 90%. The administrator allocated additional RAM to meet the vendor's recommended specifications. However…

The correct answer is D. Check the performance log data. Check the performance log data: Reviewing performance logs will provide insights into what is causing the database to run slowly, such as high disk I/O, CPU bottlenecks, or network issues. This is a logical next step to identify specific performance-related problems rather than…

Troubleshooting

Question

A user reports that a database is slow. The RAM utilization on the server recently jumped to 90%. The administrator allocated additional RAM to meet the vendor's recommended specifications. However, the user reports that the database continues to run slowly. Which of the following troubleshooting steps should the administrator take next?

Options

  • ARemove any recent patches.
  • BContact vendor support.
  • CAllocate an additional 64GB of RAM.
  • DCheck the performance log data.

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    15% (4)
  • C
    4% (1)
  • D
    77% (20)

Explanation

Check the performance log data: Reviewing performance logs will provide insights into what is causing the database to run slowly, such as high disk I/O, CPU bottlenecks, or network issues. This is a logical next step to identify specific performance-related problems rather than jumping to solutions without understanding the root cause.

Topics

#Troubleshooting#Performance monitoring#Server administration#Database performance

Community Discussion

No community discussion yet for this question.

Full SK0-005 Practice