Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 5:27 AM
Points: 116, Visits: 656
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