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

Published Jan 15 2019 10:45 AM 43 Views
Microsoft
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: