DPA -- See the Stored Executed Procedure Call

eralmond

If there anyway in DPA to see the actual Stored Procedure Call Request Statement of a long waiting query?

Find more posts tagged with

executed

call

procedure

stored

Accepted answers

All comments

FormerMember

Hi Eric,

What database type are you inquiring about (SQL Server)? What is the message you see?

Kathy

eralmond

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?

FormerMember

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