Measuring SQL execution time ?

Hi,

I am interested in timing some SQL calls for a hardware comparison, and I am aware of the timing function in SQL. The problem is this is actual clocked time, from start to finish. It includes time the CPU may have used to do other things and serve other users.

Is there any other way to measure CPU cycle associated with this call >?

I am also wondering if there is an easy way to simulate a large user load and make timing measurements "under load".

Any pointers, and sugestions will be appreciated !

Maurice De Vidts
ceham_at_w3eax.umd.edu Received on Wed Jun 12 1996 - 00:00:00 CEST