Here is the profiler entries from UAT Server

Audit Login-- network protocol: TCP/IP 4748103

RPC:Completedexec dbo.usp_CaseProcessContact_And_ 0240034748103

Audit Logout 015895146290134748103

RPC:Completedexec sp_reset_connection 0000 4748103

Procedure took 3 ms, overall from login to Logout took 13 ms. Connection is reset is App pool as expected. Looks good.

Same Sequence on Prod Server

Audit Login-- network protocol: TCP/IP 474878

RPC:Completedexec dbo.usp_CaseProcessContact_And_ 47656474878

Audit Logout010471717687126474878

RPC:Completedexec sp_reset_connection 0000 474878

Procedure took 6 ms, But logout took 126 ms, and connection is reset in App pool. The differences of ~100 ms on each of the logouts being repeated 80 times is accumulating the 8 seconds (I believe).

Of course, the Applications/Web team says it is a database issue and I am telling them the application is taking to long to disconnect.

Are there any settings in the App pools on the webservers that might contribute to this?

Any input would be appreciated.