Too many connections?
Posted on 2006-11-17
I was wondering if this sounds OK, or if something is wrong-
We have an enterprise ERP system that all network users can access running on SQL Server 2000 Enterprise, on a Windows 2003 Server. We have about 60 - 70 users total that use the system.
My question is this: when I go into Enterprise Manager and look at the current activity, there can be as many as 600 processes at times. You can see each user, and some users have 10, 20 or even 30 connections. The app is written such that each user must open two or three different programs to use it (ex: Order Entry, Purchasing, Engineering...). These are all separate executables.
Is this normal to have this many connections? Will it hurt anything?
Performance of the applications seems OK.