posts - 220, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

Login Events include Pooled Connections

Every now and then I stumble across something and say "I know I knew this before!"  In Profiler, the Audit Login event includes regular logins and connection pooling reuse.  If you run a trace and see a large number of logins you'll need to include the EventSubClass column to determine if they are pooled connections.

Image of Profiler showing pooled and non-pooled connections

Even more misleading is PerfMon.  If you capture the SQLServer:General Statistics - Logins/sec counter you'll see regular logins and connection pooling reuse.  I haven't found a way to have PerfMon just show me "real" logins and not connection pooling events.  I've started watching User Connections and Logouts/sec to see how many logins are really happening.  Logouts/sec doesn't report anything related to connection pooling.

On SQLTeam.com I have roughly twenty logins per second but under one logout per second while the number of connections is stable.  That tells me I really have one "real" login per second and nineteen connection pooling reuse events per second.

Print | posted on Wednesday, October 31, 2007 8:52 AM | Filed Under [ SQL Server Stuff ]

Feedback

Gravatar

# re: Login Events include Pooled Connections

I don't have a checkbox for the column EventSubClass for event Audit Login. I'm using SQL 2005 profiler for a 2005 SQL server. Why would this be?
11/6/2007 1:12 PM | Don Schaeffer
Gravatar

# re: Login Events include Pooled Connections

Did you check the Show All Columns checkbox? It's down in the lower right.
11/7/2007 10:53 AM | Bill Graziano
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET