Our production server is running SQL Server 2008 (non r2).
I'm working on investigating and issue that appears to be networking or connection related, where our web server is losing or dropping connections to the database server.
It would assist me greatly to have a method or counter that I can use to track DROPPED connections to the SQL Server. Specifically, we want to know if the ODBC/ADO connection was forcibly closed by the CLIENT.
Conceivably we could also track when a query was cancelled by the client, which may give us the same information.
From my own research I don't see a way to track this with perfmon counters, but I'm not that familiar with them.