• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Too many connections?

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.

1 Solution
'Normal' is really in context of the application. Your server performance is fine, so you aren't experiencing any impact of this. Check to see if any of those connections (use sp_who2) have a really old time in the LastBatch column. This would suggest that the application is not cleaning up it's idle connections - which is generally not considered good practice ;)

However, not knowing the application architecture, they may have had valid reasons to do this (and if they have multiple connections open, the applicaiton might be performing multiple concurrent tasks as well). Bottom line is that if your server can comfortably handle this, then there is no problem.
Eugene ZCommented:
<Performance of the applications seems OK.
then it is ok
mayfran-itAuthor Commented:
OK, thanks!
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now