2

What does an SQL:StmtStarting event originated from application mean? Does it mean a raw SQL statement executed directly from the application?

For example, in the case of an SP:StmtStarting, it means that the current statement is inside an stored procedure, and thus not directly executed by the application, but by the stored procedure.

2

Yes, this is an ad hoc SQL statement that is not part of a module. It could be sent on its own or it could be part of a batch.

Though I'm not sure why you're using Profiler; it is notoriously horrendous for performance. Just take a look at what Joe Sack observed regarding the impact Profiler has on throughput and similar observations by Jonathan Kehayias.

Or what value you gain from collecting the Starting events. The Completed events tell you much more about what happened (including things like duration).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.