Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Audit Logout / Audit Login - Pooled Connection Expand / Collapse
Posted Friday, March 22, 2013 5:53 AM


Group: General Forum Members
Last Login: Tuesday, November 15, 2016 6:16 AM
Points: 126, Visits: 742
I am experiencing intermittent connection drop outs on one of our applications which connects to our production database server.

I have been profiling the instance to check the connections and i've noticed something odd with regards the audit login and audit logout events.

Sometimes, the audit login uses a non-pooled connection but the associated logout event shows a pooled connection.

Sometimes, the opposite occurs. The login uses a pooled connection and the associated logout shows a non-pooled connection.

The majority are both pooled but every now and again the above scenario occurs.

How is this possible?

Post #1434212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse