A lot of process id in awaiting command in SQL SERVER 2000

We have an application using a lot of process id
40 and more for 1 user !

Is it normal ?
The process is sleeping !

When we have 3 users we have 100 or more process id sleeping.

Configuration : SQL SERVER 2000
Application is in Windev.

Do you think that the application don't close the connection and open  a new one for each query ?

Thanks
jff218Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
If the user is in fact used by web applications, this could be normal, as in most cases, the connections are pooled, hence a certain amount of connections stay "available".
0
 
jff218Author Commented:
it's not a web application

The server is very slow when we have 3 or 5 users (in a local network).(Windows SBS 2003) but only sql server

How long is the life of a connection between client and sql Server 2000 ?

thanks
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>How long is the life of a connection between client and sql Server 2000 ?
as long as the connection is not closed from the application, it remains open. there is no automatic connection closing mechanism.
0
 
jff218Author Commented:
a process id means a connection  ?

So if i have 50 process id for the same user,on the same database, i have 50 connections ?
Or only one connection ?

do you know if that use MEMORY or slow SQL SERVER ?

Thanks
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>a process id means a connection  ?
yes.

>do you know if that use MEMORY or slow SQL SERVER ?
each connection uses of course a bit of memory, but should not necessarly slow down sql server as such.
however, if each connection has open transactions (ie holding locks), THAT will slow down sql server, as the locks need to be managed and respected for all the other transactions...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.