15 April,2011 by Jack Vamvas
When analysing the full Query Response time , it is of value to break the cycle down into 3 stages. This will allow greater understanding of what is occurring and how to resolve any delays.
These three phases , will equal Total Time time taken for a query to respond.
CPU (Running) = When in Running mode ,only one session can be executing, per scheduler
Wait time (suspended) = The session is waiting for an event to complete to complete e.g Async_io_completion
Signal Wait time (Runnable Queue Time) = Time spent in runnable queue is waiting for CPU