Can DPA show the call stack for a user-defined function?

RBL 5 months ago

We have recently seen a sudden jump in the frequency a specific user-defined function is called. Can DPA be used to identify the call stack, to show us the most frequent callers for this function?

Parents

0 jaminsql 5 months ago

Might not be super easy to zero in on that in DPA unless the UDF is also a performance issue in the top 15 or top X charts now.

I would say try using the Find SQL function to look for calls and then the hash items of those in DPA and then select them and look at supporting data tabs might work but, also be many steps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 jaminsql 5 months ago

Might not be super easy to zero in on that in DPA unless the UDF is also a performance issue in the top 15 or top X charts now.

I would say try using the Find SQL function to look for calls and then the hash items of those in DPA and then select them and look at supporting data tabs might work but, also be many steps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data