I am running SQL Profiler 2008 on my application so that it is better to see what my application is doing at the DB level. There are some columns in the output which are unclear as to what I mean:
1) SPID: I am using the same connection to DB to perform all my database activity. Still, I look at many different SPID values. What does SPID do? I would have thought that since I am using the same connection, I will see only one SIDID.
2) Event Suction: 'RPC: Complete' for Event Class I see the value of this column. EventClass 'for SQL: StmtCompleted' I do not see anything
Thank you.
Google is your friend.
The first link indicates that this session ID is
The first link indicates that it indicates the actual order of events.
For a connection to your multiple session IDs, keep in mind that the default settings for connecting to a SQL Server data source (using the ADO .NET) .net connection pooling, which means that < There is no 1: 1 ration between code> SqlConnection examples and actual database connection.