SQL Server 2005 SP2 – Trace Event Change – Connection Based Events
Published Jan 15 2019 10:45 AM 95 Views
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

Version history
Last update:
‎Jan 15 2019 10:45 AM
Updated by: