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 ?