Solved

Too many connections?

Posted on 2006-11-17
3
231 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
[X]
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
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:Eugene Z
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

733 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