SQL Server 2005 SP2 – Trace Event Change – Connection Based Events

  • Article

Starting with SQL Server 2005 SP2 the connection based events are also produced for sp_reset_connection activities, indicating the connection was reset. The pattern will look like the following.

RPC:Starting sp_reset_connection
Disconnect Subclass = 2
RPC:Completed sp_reset_connection
Connect Subclass = 2

The subclass = 2 indicates that the connection based events are not physical connection activities but the logical reset operations.

When attempting a reply you will first want to filter out the Connect and Disconnect events with subclass = 2.

- Bob Dorr