|
|
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?
Navigation:
[Reply to this message]
|