First published on MSDN on Mar 29, 2007
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
