Page 1 of 1

Show stored procedure ID in the performance info

PostPosted: Fri Sep 10, 2010 10:10 am
by martinh
When I run a trace on SQL-Server level I see that Servoy generates stored procedures. Some of those SP have lot of reads, take long time or take lot of CPU. But the statement executed is

exec sp_execute 29, 1,1,28

What I can see, is that 29 here is the SP-ID, the other values are the SQL-parameters.
Please show this SP-ID on the performance info in the application server, so that I can see what query is behind this SP.

Is there another way, how I can determine what SQL-statement is behind SP 29?

This request was added as case #318742

Re: Show stored procedure ID in the performance info

PostPosted: Fri Sep 10, 2010 10:35 am
by rgansevles
Martin,

Servoy does not generate stored procedures, we only speak sql select/insert/update/delete via the jdbc driver.

What you see is probably created by the driver and is internal to the db, there is no way Servoy can figure out what sproc 29 is.

I would expect slow/frequent queries to show on the top of the performance section on the admin page.

Rob

Re: Show stored procedure ID in the performance info

PostPosted: Sat Sep 11, 2010 7:26 am
by sbutler
You can also use something like this if you want to "spy" on the SQL that servoy generates: http://code.google.com/p/log4jdbc/