Craig wrote:

>Hi all,
>
>I hope that you can help. We have a situation with our tool where the
>multi-threading apps that we have created lock up at random intervals and
>report deadlocks. This does not seem to be OS platform related or Firebird
>version related and we are looking at some better control to try and avoid
>this, but with an app our size this is quite a task. In the mean time I
>would like to run some form of tracing tool that can monitor down to the SQL
>level sent to firebird to try and see if there are some specific areas we
>should work on first. We have been looking at a tool from CA called Vantage
>that gives this level of detail, but the price tag is a bit on the steep
>side. Does anyone know of any other tools that can assist? We have a two
>tier app that has a Delphi front end and a Firebird (1.5 CS) database. We
>are even getting these issues when the database is stored on a Linux OS.
>
>Any help would be appreciated,
>
>Regards
>Craig
>
>
>

Craig,

It's a usefull tool that FB misses, I like a lot MSSQL Trace to help
debug some applications.

Some components suites have a SQL monitor, that could be used to trace
the queries, you could give it a try.

Another option, not so good as a real SQL tracer, but can help: Try a
Network snniffer, you can see all network traffic, so the SQL commands
will be captured too, but you will have to search for the SQL on a bunch
of data, this could be usefull if you can isolate a client station (or
trace just one IP). I think Ethereal has some filter plug-in to help
trace some kinds of packets, don't know if it can be used to create a
pattern to filter just SQL commands.

HTH

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.1 - Release Date: 04/03/2005