If there anyway in DPA to see the actual Stored Procedure Call Request Statement of a long waiting query?
Kathy,
SQL 2008. It's not a message that I'm seeing...
The tool is great at disclosing the procedure and what part of the procedure that's causing waits.
What I'm trying to determine is -- where can I find what parameters were used to execute that specific procedure call?
Hi Eric
From our support team:
We trap literals used for the parameters the first time we poll for SQL text that was used for the latest compilation as of that poll for that SP and SQL statement. Those literals can be viewed in Management Studio by exporting the plan from DPA to an xml doc and opening in SSMS.
We don't do any specific parameter sniffing at this time.
Kathy
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.