SLEEPING/AWAITING COMMAND question

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?


.

Relevant Pages

  • How to enable Windows Authentication
    ... web app using information from ... it and authenticate with a known good user name and password from my local ... Web.Config (notice the commented out connection string) ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP.Net with IIS and SQL Server in different hosting companies
    ... Yes, theoretically, you can host SQL Server and your web app far from apart. ... If the communication between the two hosts is via regular internet connection, as you use at home "High-Speed", say, a few Mbp, then your web app would be literally useless. ... The project will basically involve an ASP.Net 2.0 application and a database (ideally MS SQL). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Is SQLExpress binaries required on server for forms authentication to work?
    ... I am working on an ASP.NET 2.0 web app that uses forms authentication ... "An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • audit tables, delete triggers and sql server authentication
    ... i have a web app connecting to a sql server using sql server ... the web app however, is using windows authentication. ... i have an updatedby and an updatedate. ... how can the trigger know ...
    (microsoft.public.inetserver.asp.db)
  • DirectoryServices
    ... A system that is being designed will use ActiveDirectory to store ... userinformation for a SQL Server 200 base web app. ... to AD after getting the windwos user account from SQL Server. ...
    (microsoft.public.dotnet.framework)