Hi

I have a SQL 2008 R2 standard edition server.

I selected the Login/Logouit events in the SQL profiler & clicked on a new connection to the server via the SSMS.

Now in the profiler I saw 3 entries related to this action of mine.

An immediate Login & logout of my login .. Why does this happen

What if I dont want to see such login & logout that happen within a second & are duplicate reords.. in my trace file.

Please advice

Thanks

Hello,

Audit Login/Logout event class are fired by new connections or by connections that are reused from a connection pool.Connections with the same configuration are pooled, and connection is not actually closed when it is returned to the connection pool. Connection pooling reduces the number of times that new connections must be opened.

Audit Login/Logout event is not an indication that there is a performance issue.If you don't want to track all events, you can specify the column filter on the Profiler.

Reference:http://stackoverflow.com/questions/279401/sql-connection-pooling-and-audit-login-logout

Regards,
Fanny Liu