Re: Measuring SQL execution time ?

> 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".

Many operating systems (VMS, UNIX) will give you elapsed CPU time and total elapsed time for your operations. To simulate loads, we use batch jobs to logon up to 55 concurrent users and have them all launch a set of queries of varying degrees of complexity. It stresses the system quite well. How you would do this depends upon your operating system. If you could provide more details on your environment, I'm sure you would get more detailed help from the generous folks at this group. :-)

--brad Received on Thu Jun 13 1996 - 00:00:00 CEST