This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

DPA -- See the Stored Executed Procedure Call

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

  • FormerMember
    0 FormerMember

    Hi Eric, 

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

    Kathy

  • 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
    0 FormerMember in reply to eralmond

    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