Solved

I have a high count on active connections is this normal

Posted on 2011-03-10
3
1,734 Views
Last Modified: 2012-05-11
Take a look atthe attached pic and tell me what you think.
this is a front end sql server that serves 50 or so people. the back end on this is a massive dl 380 g7 with 16 hard drives in a raid 10 and 32 gigs of ram and 2 6 core procs that are hyper threaded.
giving you a total of 24 cores.
However this server is a dell 2800 with 2 3.0 ghz 800 FSB CPU's and server 2003 r2 and 4 gigs of ram
0
Comment
Question by:explorer648
[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
  • 2
3 Comments
 
LVL 41

Expert Comment

by:Adam Brown
ID: 35101716
I think you might have forgotten to attach the picture.
0
 

Author Comment

by:explorer648
ID: 35102298
Yeah sorry about that here is the pic
prefmon.png
0
 
LVL 41

Accepted Solution

by:
Adam Brown earned 500 total points
ID: 35113157
That's actually not a very high number. As an example of what is showing on my home test server (the one only I use) I've attached a screenshot of my perfmon. Note that it shows 501,000 connections active. It should be noted that an "Active Connection" will initiate the second someone requests any resource on the server (DNS, SMB, Exchange connections, etc.). Connections can stay "active" for a very long time. An active connection includes anything in a wait state, a listening state, or an established state. You can view the active connections by running netstat from the command line to get a better idea of what types of connections you have open. http://www.windowsreference.com/free-utilities/how-to-view-active-tcp-and-udp-connections-in-windows-server-2008vistaxp2000/ also has a link to a useful utility that will let you view all connections on the computer. I can't find any information on exactly how long an "Active Connection" lasts in Windows, but given the number of connections open on my system and the fact that it's been online for about a month or so without reboot, they probably hang around until a reboot occurs.
Active-Connections.GIF
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article shows the method of using the Resultant Set of Policy Tool to locate Group Policy that applies a particular setting.
A hard and fast method for reducing Active Directory Administrators members.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

630 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