A connect line that shows the connection handle and database user name is printed after the first transaction begins and before the next transaction starts. This information is printed only once per database connection. For example:
I. 04/23 13:02:37. 0000000003 Connect: SA connHandle: 1 SA connID: 3 IQ connID: 0000000003 User: DBA
You can use this connection information to match query plans in the .iqmsg file with query text. Run the stored procedure sp_iqcontext to determine what statement each connection is executing at a given moment.
To correlate connection information in the -zr log
file with that in the .iqmsg file,
see “Correlating connection information”.
