Determine if application is re-using SQL Connection
Posted
by Steve Evans
on Server Fault
See other posts from Server Fault
or by Steve Evans
Published on 2010-05-04T19:03:47Z
Indexed on
2010/05/04
19:09 UTC
Read the original article
Hit count: 236
I have a legacy app that connects to my SQL 2008 server. I'm trying to determine if the application is re-using it's connection to the SQL server or is creating new connections on a regular basis.
Using SQL Profiler I've audited for login events, but that appears to generate an event every time a SQL statement is executed even with apps that I know are maintaining their connection to SQL.
© Server Fault or respective owner