Zorka and Zico, I'd like to have HTTP and SQL traces combined

[Marius Jokubauskas]

I'am currently testing ZORKA on apache tomacat server witch uses SQL call, to invoke stored procedures.

1) I'd like to have my traces include HTTP and SQL traces. I this way that i could see combined attributes from HTTP and SQL is it possible using zorka agent?

This means that in single HTTP transaction i'd like to see SQL query 

2) In SQL traces I can see only 

SQL=SELECT 1 FROM DUAL

i'd like to see procedure calls.

--------------------------------------------------------------------------------

My configuaration: 

scripts = jvm.bsh, zabbix.bsh, eclipse/jetty.bsh, zico.bsh

zorka.hostname = zico.localhist

zorka.log.level = DEBUG

zorka.log.spy = INFO

zorka.log.tracer = INFO

tracer = yes

tracer.net = yes

tracer.net.addr = 127.0.0.1

tracer.net.port = 8640

tracer.min.method.time = 0

tracer.min.trace.time = 0

tracer.file = yes 

tracer.file.path = ${zorka.log.dir}/trace.trc

tracer.file.fnum = 8 

tracer.file.size = 128M 

tracer.file.compress = yes 

zorka.spy.compute.frames = yes

spy = yes

[Rafal Lewczuk]

Hi,

Tracer already combines SQL queries into HTTP requests. Double click on HTTP trace and then expand whole call tree using fourth icon from left in method tree panel.

Please remove tracer.min.method.time setting as it will make traces unreadable (it is useful only when tuning tracer).

Regards,
rle

[Marius Jokubauskas]

Thanksf or your response,

Sure, i used tracer.min.method.time just to see whats happening  in traces..

Ok. But I still can't see sql attributtes i'd like to see:

 

[Rafal Lewczuk]

Hi,

Please make sure you've added script for instrumenting proper JDBC driver, for example jdbc/mssql.bsh.

Regards,
rle

[Rafal Lewczuk]

 (sorry for answering so late BTW)