Solved

Too many connections?

Posted on 2006-11-17
3
240 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 43

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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…

695 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