Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Too many connections?

Posted on 2006-11-17
3
225 Views
Last Modified: 2008-01-09
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.

Thanks,
Jim
0
Comment
Question by:mayfran-it
3 Comments
 
LVL 29

Accepted Solution

by:
Nightman earned 125 total points
ID: 17968666
'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.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17973410
<Performance of the applications seems OK.
then it is ok
0
 

Author Comment

by:mayfran-it
ID: 17978599
OK, thanks!
Jim
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question