Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Performance monitor



Permlink Replies: 1 - Last Post: Jul 12, 2014 2:34 PM Last Post By: Jeff Overcash (... Threads: [ Previous | Next ]
Damian Slanovic

Posts: 42
Registered: 3/23/04
Performance monitor
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 12, 2014 1:14 PM
Hi everybody.

There is a way to know what is the current statement IB is executing from within a stored procedure?

In the "statements" tab of the performance monitor, I see the sentence
EXECUTE PROCEDURE sp_depuracion_blanqueo_base_de_datos( ?, ? )

But I want to know the exact sentence that is in the stored procedure.

Regards.
Damian.
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Performance monitor
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 12, 2014 2:34 PM   in response to: Damian Slanovic in response to: Damian Slanovic
Damian Slanovic wrote:
Hi everybody.

There is a way to know what is the current statement IB is executing from within a stored procedure?

No, only that the SP is running. Long running statements might be noticable by
what tables are getting hit on the tables page though.

In the "statements" tab of the performance monitor, I see the sentence
EXECUTE PROCEDURE sp_depuracion_blanqueo_base_de_datos( ?, ? )

But I want to know the exact sentence that is in the stored procedure.

Regards.
Damian.

Nope, The SP is one big BLR and there are no debugging type hooks to actually
see what line it is on at any given time.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
And so I patrol in the valley of the shadow of the tricolor
I must fear evil. For I am but mortal and mortals can only die.
Asking questions, pleading answers from the nameless
faceless watchers that stalk the carpeted corridors of Whitehall.
(Fish)
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02