Re: running out of ports

From: Ken Schaefer (kenREMOVE_at_THISadopenstatic.com)
Date: 01/20/05


Date: Thu, 20 Jan 2005 11:35:32 +1100

Suggest you use TCPView to determine what process owns those ports - it may
not be SQL Server at all.
http://www.sysinternals.com/ntw2k/source/tcpview.shtml

Cheers
Ken

"Stefan Berglund" <keepit@in.thegroups> wrote in message
news:765tu09bc5nqggg7u0t8loi31ei0mvtoup@4ax.com...
> netstat -a yields the following:
>
>
> Active Connections
>
> Proto Local Address Foreign Address State
> TCP stefs-server1:smtp stefs-server1:0 LISTENING
> TCP stefs-server1:http stefs-server1:0 LISTENING
> TCP stefs-server1:epmap stefs-server1:0 LISTENING
> TCP stefs-server1:https stefs-server1:0 LISTENING
> TCP stefs-server1:microsoft-ds stefs-server1:0
> LISTENING
> TCP stefs-server1:1025 stefs-server1:0 LISTENING
> TCP stefs-server1:1026 stefs-server1:0 LISTENING
> TCP stefs-server1:1032 stefs-server1:0 LISTENING
> TCP stefs-server1:1051 stefs-server1:0 LISTENING
> TCP stefs-server1:1076 stefs-server1:0 LISTENING
> TCP stefs-server1:ms-sql-s stefs-server1:0 LISTENING
> TCP stefs-server1:3372 stefs-server1:0 LISTENING
> TCP stefs-server1:4152 stefs-server1:0 LISTENING
> TCP stefs-server1:6051 stefs-server1:0 LISTENING
> TCP stefs-server1:6052 stefs-server1:0 LISTENING
> TCP stefs-server1:6150 stefs-server1:0 LISTENING
> TCP stefs-server1:6935 stefs-server1:0 LISTENING
> TCP stefs-server1:6936 stefs-server1:0 LISTENING
> TCP stefs-server1:6937 stefs-server1:0 LISTENING
> TCP stefs-server1:6938 stefs-server1:0 LISTENING
> TCP stefs-server1:6939 stefs-server1:0 LISTENING
> TCP stefs-server1:6940 stefs-server1:0 LISTENING
> TCP stefs-server1:6941 stefs-server1:0 LISTENING
> TCP stefs-server1:6942 stefs-server1:0 LISTENING
> TCP stefs-server1:6943 stefs-server1:0 LISTENING
> TCP stefs-server1:6944 stefs-server1:0 LISTENING
> TCP stefs-server1:6945 stefs-server1:0 LISTENING
> .
> .
> .
> .
> This continues for five or six thousand ports. What gives? The
> machine recently ran for 56 days with no problems. I had to
> reboot it because of this problem and now every couple of days it
> runs out of connections and has to be rebooted.
>
> SQL Server is the only software running on the box and SELECT
> @@VERSION yields:
>
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
> 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> Any ideas? Is there a more appropriate group?
>
>
> ---
> Stefan Berglund