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?
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.