SQL Server Profiler - Column Meanings

Can anyone point to a ref开发者_运维知识库erence which describes what is being returned in the IntegerData and IntegerData2 columns. I am particularly interested in their meaning for SQL:StmtCompleted event.

---

It varies by event. See here for SQL:StmtCompleted:

http://msdn.microsoft.com/en-us/library/ms189886.aspx

---

IntegerData returns the actual number of rows returned by the query.

---

You can check out the SQL:StmtCompleted MSDN documentation:

IntegerData   int    Number of rows returned by the statement.
IntegerData2  int    End offset (in bytes) of the statement that is being executed.

There are similar specifications for almost all other profiler events, under the SQL Server Event Class Reference MSDN chapter.