Performance Quiz1

Thought I would put a few quiz questions together for performance engineers. Some of the questions are related to tools such as WireShark and Oracle AWR while the rest are generic!

Which of these systems are potentially suffering CPU saturation with a CPU queue length of 8.

For a column in a database table what is cardinality a measure of?
There are 15 concurrent users on the system with an average time in the system of 10 seconds. 
APDEX has a T value if 4 seconds what response time are users receiving a frustrated response time?

You are asked to provide the 95% percentile response time measurement for transaction X, how is that calculated

Tarpitting is the name given to purposely delaying incoming connections to a process/server, what would be a valid reason for using this.

Below is an extract from an Oracle AWR report, What was the CPU utilization?

Host Name Platform CPUs Cores Sockets Memory(GB)
---------------- -------------------------------- ---- ----- ------- ----------
xxxxxxxxxx.local Linux x86 64-bit 2 2 1 7.80

Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 77 05-Dec-17 09:50:00 112 3.2
End Snap: 78 05-Dec-17 10:00:00 112 4.5
Elapsed: 10.00 (mins)
DB Time: 0.39 (mins)
Here is a graph of Throughput against workload. Would response time of the system be greater at point Y compared to X.

You are monitoring a single threaded executable process on a 4 core computer, the process is running a highly computational task that does not access disk and assuming there is no memory pressure. What CPU utilization be reported?
You are monitoring a 3 threaded executable process on a 4 core computer on windows, each thread is able to consume as much CPU available. What would the perfmon report for the %Processor Time for the Process (not the processor) report
What is the order for messages exchanged in a TCP connection request?
For linux IOSTAT command the await column provides:
In wireshark what filter would you use to get all HTTP page requests talking more than 2 seconds
On VMWare what is the first thing it does to gain more more memory?


HTTP/2 is the new HTTP standard, what performance improvement does it offer

Leave a Reply

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