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

I have a high count on active connections is this normal

Posted on 2011-03-10
3
1,695 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
  • 2
3 Comments
 
LVL 39

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 39

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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

Suggested Solutions

Title # Comments Views Activity
Powershell to query AD 3 35
How can i confirm Password policy is working? 8 15
Extend AD schema for SCCM 2012 3 26
Modify Permissions in Windows Folders. 15 30
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
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 …

856 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