How to profile SQR code?

[Schiff Fred <FSCHIFF@NLFS.COM>]

How do I go about profiling a piece of SQR code?
I want to see whats taking so long.  I have a program which takes 2 hours to
run.
It produces seperate reports for around ~800 people, and the time has gone
up
as the number of reports it has to produce has gone up.  I'm pretty
confident
that the queries are all ok, but I'd like to know for sure.

The real problem is that I have to run the sqr report multiple times because
of
formating and where clause constraints, so its actually taking 6 hours every
night.

Fred Schiff (fschiff@nlfs.com)
212/354-8800 x250
Nathan & Lewis Securities, Inc.