Using an Event Monitor to Capture Statements with Values for Parameter Markers

Recently, I needed to do some SQL profiling – discovering exactly what SQL a web application was executing against the database. I learned a lot, and when I learn a lot, I try to share with my readers.

I went into this exercise with two major misconceptions:

  1. A statement event monitor would collect parameter marker values
  2. Event monitor table output would be well documented and easy to figure out

I had the first misconception proven wrong pretty immediately.… Read the rest

Continue reading »