SQL Server - Query Response Time measure

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

Read More

Perfmon ,Waits and Queues - SQL Server DBA

SQL Server - How to improve Execution Plan Reuse - SQL Server DBA

Performance Top Queries by Total CPU - SQL Server DBA


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL Server - Query Response Time measure


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer