Hi everyone,
We have several applications written in Delphi 7 that over the years
have had a lot of SQL added into the processes. We're now seeing SQL
server performance issues and are trying to determine what queries might
be causing server load. I've looked at a couple profiling packages,
such as gpProfile but in order to get specific profiling information on
various SQL statements, code loops or data validation we have to
refactor the questionable code to a procedure or function. Are there
profiling packages out there that would allow us to insert markers
around specific blocks of code for analysis rather than only profiling
at the procedure/function level?
Thanks!
==================================================
Eric Grange's Delphi Sampling Profiler allows you to enable and disable
profiling at a per statement level.
OutputDebugString('SAMPLING ON');
OutputDebugString('SAMPLING OFF');
Their Web site was down when I just checked:
http://www.delphitools.info/
but I see it on Torry:
http://www.torry.net/authorsmore.php?id=7200
http://www.torry.net/tools/debug/profilers/SamplingProfiler1.8.1.zip
Cheers,
David
--
SatSignal Software - Quality software written to your requirements
Web: http://www.satsignal.eu
Email: [email protected]
_______________________________________________
Delphi mailing list
[email protected]
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi
