This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DPA Report on Stored Proc Impacts

Want to know what kind of aggregate impact specific stored procs have on your end users? Now you can know.

Steps:

  1. Bring up DPA in your browser.
  2. Click on "Reports" in the upper right of the interface.
  3. Select the instance you are interested in within the Database Instance dropdown.
  4. Select "Top SQLs" within the Report Type dropdown.
  5. Select Report Options button.
  6. Under the Programs to Display section, select the "User-Defined Programs" radio button.
  7. Click the add button. A search popup wizard will display.
  8. Enter "<SPROC NAME>" in the search string area and click the search button.
    pastedImage_0.png
  9. It will likely take you to a page in the wizard where you will have to choose the SQL Text radio button, then click search again.
  10. Highlight all of the SQL statements and click OK.
    pastedImage_3.png
  11. Click OK again.
  12. Click Display Report on the main dialogue view.
    pastedImage_6.png
  13. And the results - you can even display the SQL text below the wait time impact graph.
    pastedImage_5.png