Show stored procedure ID in the performance info

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Show stored procedure ID in the performance info

Postby martinh » Fri Sep 10, 2010 10:10 am

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
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium

Re: Show stored procedure ID in the performance info

Postby rgansevles » Fri Sep 10, 2010 10:35 am

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
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Show stored procedure ID in the performance info

Postby sbutler » Sat Sep 11, 2010 7:26 am

You can also use something like this if you want to "spy" on the SQL that servoy generates: http://code.google.com/p/log4jdbc/
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 759
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 6 guests

cron