Re: *Measuring sql performance (elapsed time and scalability) by number of logical reads

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>
  • Date: Tue, 2 May 2006 17:13:53 +0200

response time (elapsed time) = service time + wait time.

as an aside, note that there are no counts anywhere in that formula. In your
case the service time (cpu) is the difference. Due to the peculiarities of cpu
time accounting, wait time is -0.01 for both of your queries, but plan 1 takes 4
times the cpu to do the work.

Is there a way to get information about how (calls to hash function or something else) service time (CPU) is used up ?
Something that makes clear the difference between the two fetch actions.

Fetch        2      0.26       0.25          0       1725          0  1
Fetch        2      0.06       0.05          0       7559          0  1



Other related posts: