Thursday, May 2, 2013

Using Profiler to get list of SPs on some specific pages in application

  1. Run Profiler
  2. Choose TSQ_SPs Template
  3. On the Event Selection tab select "Show all columns" checkbox
  4. On the same page check only one event: SP:Completed
  5. On Colum Filters set filters for ApplicationName, DatabaseName, HostName, LoginName. Actually it's enough only DatabaseName and HostName. HostName as my computer name, because I run application locally from VS.
  6. Save Trace properties as Template.
  7. Run trace
  8. Run application.
  9. Before loading required page clean trace
  10. Open page and pressing different buttons and controls on the page
  11. After you finished with all actions on the page, save Trace as Trace Table to db.
  12. Running the following query:
    and getting list of SPs for this page. DISTINCT allows you to eliminate repeating SPs, because on each page SPs run many times.


  1. What a information of un-ambiguity and preserveness of valuable knowledge about unpredicted emotions.

    My website ... diarrhea Remedies

  2. Thanks for some other informative web site.
    The place else could I am getting that type of information
    written in such a perfect means? I have a challenge that I am simply now working
    on, and I've been on the look out for such info.

    Feel free to visit my page: recycling facts

  3. You're so cool! I do not think I've read something like this
    before. So good to discover another person with genuine thoughts
    on this subject. Seriously.. many thanks for starting this up.
    This site is one thing that's needed on the web, someone with a little originality!

    Take a look at my blog post

  4. Awesome! Its in fact remarkable post, I have got much clear idea regarding from this paragraph.

    Feel free to visit my web-site :: permanent hair straightening