I am looking for any tool that will allow testing / tuning Sybase nested stored procedures. There are many tools and, of course, Sybase for tuning performance and testing SQL, but none of them can handle nested stored procedures (i.e. a stored process that calls another stored process). Does anyone know / know such a tool?
I don’t know anything that does this, but I would like to see a tool that does this. What I usually do in this situation is to try to determine which of the nested stored procedures consumes the most resources or uses the longest and then tune the performance of this procedure in isolation.
I'm not sure which Sybase DB you are currently using, but have you tried Profiler in Sybase Central? Right-click on the DB connection and select PROFILE (or PROFILER ???)
, , SP . , , -SP, SP, , , .
, .
,
, Sybase "SET FMTONLY", "SET NOEXEC", .
:
: sp_B sp_A sp_B
sp_A sp_B
SET SHOWPLAN ON GO SET FMTONLY ON GO sp_A GO
. sybase... ASE 12.5, ASE 15. set showplan noexec