Posted by Chad on 10/01/45 11:33

I am using SQL Server 2000. In Enterprise Mgr, under Management/Current
Activity, I see a list SPIDs.

I have a multi-tiered .NET web app that uses ADO.NET to connect to the
database. Each time a Stored Proc is called, a new connection is opened, the
data retreieved, and the connection closed and set to Nothing (in VB.NET).

Yet, I see several (15 or so) SPIDs for the user ID that the web app uses to
connect to the database.

The database is local and private, so I know all connections are from me.

What does Status=SLEEPING Command=Waiting Command mean?

What will happen when we get 1000's users on the web app?

Is SQL doing some kind of connection pooling?

[Back to original message]