Duration far greater than CPU

• matthew_erbs

  SSC Rookie

  Points: 27

  More actions

  February 5, 2004 at 5:02 pm

  #107045

  Hi all,

  Still a beginner so patience please.  I have done a number of traces on my slow or slowing system and I have a question in relation to the cpu and duration counters.

  Most of the queries that are an issue have a duration far greater than CPU.  For some of these the CPU is near zero.

  Anything that would point me in the right direction would be great.

  Thanks,

  P.S. Also sp such as sp_who2 active are taking a varied amount of time to return results in QA. 

  

  
  Matthew Erbs

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 5, 2004 at 5:35 pm

  #492975

  The query could involve many disk I/O, being blocked or large number records travel on the network back to the client etc.

  Most likely you might have problem with your network if sp_who2 also runs slow.

  Cut and paste the slow query to QA, examine the execution plan and see whether proper indexes are used by the query.