Large number of exec sp_reset_connection calls to SQL Server 2005 -- sql server (microsoft)

time2fly NO[at]SPAM gmail.com
4/4/2007 10:20:51 AM

In looking at a sql trace in profiler I see a large number (over 1
million) sp_reset_connection calls from our ASP.NET application to our
SQL Server 2005 database.

I know that sp_reset_connection is used with connection pooling
between calls. My concern is the ratio of procedure calls to
connection resets. For every action there is over 600 connection
resets. This doesn't seem right.

Does anyone know what might cause something like this?

Todos Menos [MSFT]
4/9/2007 3:43:02 PM

I've noticed the same thing as well

I think that MS screwed up by not allowing us to keep a single
connection open in .NET

if you open a connection; it does all this other crap behind the
scense

yet another reason .NET sucks balls

-Todos

[quoted text, click to view]

sql server (microsoft) : Large number of exec sp_reset_connection calls to SQL Server 2005