I have a high count on active connections is this normal

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
explorer648Asked:
Who is Participating?
 
Adam BrownSr Solutions ArchitectCommented:
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
 
Adam BrownSr Solutions ArchitectCommented:
I think you might have forgotten to attach the picture.
0
 
explorer648Author Commented:
Yeah sorry about that here is the pic
prefmon.png
0
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.

All Courses

From novice to tech pro — start learning today.