What is the correct sequence in which the above activities should be performed to diagnose and reduce potential performance issues?

You find that the OS utilization is over 40% in your database server. Examine the following set of
performance monitoring-related activities:

1. Investigate the operating system for network transfers, paging, and swapping.
2. Check the SQL and the transactions submitting the SQL for optimal execution.
3. Investigate the top SQL by CPU utilization.
4. Consider rescheduling some work to off-peak hours.
5. Check whether there are any nondatabase jobs consuming CPU time on the machine.
What is the correct sequence in which the above activities should be performed to diagnose and
reduce potential performance issues?

You find that the OS utilization is over 40% in your database server. Examine the following set of
performance monitoring-related activities:

1. Investigate the operating system for network transfers, paging, and swapping.
2. Check the SQL and the transactions submitting the SQL for optimal execution.
3. Investigate the top SQL by CPU utilization.
4. Consider rescheduling some work to off-peak hours.
5. Check whether there are any nondatabase jobs consuming CPU time on the machine.
What is the correct sequence in which the above activities should be performed to diagnose and
reduce potential performance issues?

A.
1,5,3,2,4

B.
1,2,3,4,5

C.
2,4,5,3,1

D.
4,5,3,1,2



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is right.

you check OS first and other OS process etc.