posts - 230, comments - 423, trackbacks - 27

My Links



Follow billgraziano on Twitter

Article Categories


Post Categories


SQL Server

October 2007 Blog Posts

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. 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...

posted @ Wednesday, October 31, 2007 8:52 AM | Feedback (2) | Filed Under [ SQL Server Stuff ]

SQL Injection Comic

The world needs more SQL injection comics.

posted @ Wednesday, October 10, 2007 4:13 AM | Feedback (1) | Filed Under [ Miscellaneous ]

Powered by:
Powered By Subtext Powered By ASP.NET