Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 port 1433 in netstat -n		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

suona
Junior Member

Taiwan
121 Posts
Posted - 08 March 2004 :  19:12:45  Show Profile  Visit suona's Homepage
Running W2k/SQL7.0 ,using netstat -n, I got :

=================================================================

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    127.0.0.1:3306         127.0.0.1:4492         ESTABLISHED
  TCP    127.0.0.1:4492         127.0.0.1:3306         ESTABLISHED
  TCP    192.168.1.11:80        61.218.11.50:3407      ESTABLISHED
  TCP    192.168.1.11:80        61.218.11.50:10651     ESTABLISHED
  TCP    192.168.1.11:80        66.196.72.48:16877     TIME_WAIT
  TCP    192.168.1.11:80        66.196.90.175:41550    TIME_WAIT
  TCP    192.168.1.11:80        66.196.90.175:41571    TIME_WAIT
  TCP    192.168.1.11:80        66.196.90.221:55124    TIME_WAIT
  TCP    192.168.1.11:80        192.169.41.47:45388    ESTABLISHED
  TCP    192.168.1.11:80        192.169.41.47:45651    ESTABLISHED
  TCP    192.168.1.11:80        192.192.90.248:52718   ESTABLISHED
  TCP    192.168.1.11:80        192.192.90.248:53389   ESTABLISHED
  TCP    192.168.1.11:80        192.192.90.248:53542   ESTABLISHED
  TCP    192.168.1.11:80        192.192.90.248:54180   ESTABLISHED
  TCP    192.168.1.11:80        192.192.90.248:54663   ESTABLISHED
  TCP    192.168.1.11:80        192.192.90.248:54833   ESTABLISHED
  TCP    192.168.1.11:80        192.192.90.248:56262   ESTABLISHED
  TCP    192.168.1.11:80        192.192.90.248:57223   ESTABLISHED
  TCP    192.168.1.11:80        200.77.152.107:1676    ESTABLISHED
  TCP    192.168.1.11:80        200.77.152.107:1678    ESTABLISHED
  TCP    192.168.1.11:80        200.77.152.107:1686    ESTABLISHED
  TCP    192.168.1.11:80        200.77.152.107:1687    ESTABLISHED
  TCP    192.168.1.11:80        210.71.22.178:36536    ESTABLISHED
  TCP    192.168.1.11:80        210.71.22.178:36579    ESTABLISHED
  TCP    192.168.1.11:80        210.71.22.178:37509    ESTABLISHED
  TCP    192.168.1.11:80        210.71.22.178:37510    ESTABLISHED
  TCP    192.168.1.11:80        218.165.72.23:1069     TIME_WAIT
  TCP    192.168.1.11:139       192.168.1.12:1038      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3010      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3022      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3121      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3123      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3127      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3128      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3129      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3134      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3135      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3136      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3137      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3138      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3139      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3140      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3141      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3142      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3143      ESTABLISHED
  TCP    192.168.1.11:1433      192.168.1.11:3144      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3146      TIME_WAIT
  TCP    192.168.1.11:1433      192.168.1.11:3148      TIME_WAIT
  TCP    192.168.1.11:3010      192.168.1.11:1433      ESTABLISHED
  TCP    192.168.1.11:3022      192.168.1.11:1433      ESTABLISHED
  TCP    192.168.1.11:3112      192.168.1.11:1433      TIME_WAIT
  TCP    192.168.1.11:3122      192.168.1.11:1433      TIME_WAIT
  TCP    192.168.1.11:3124      192.168.1.11:1433      TIME_WAIT
  TCP    192.168.1.11:3128      192.168.1.11:1433      ESTABLISHED
  TCP    192.168.1.11:3130      192.168.1.11:1433      TIME_WAIT
  TCP    192.168.1.11:3135      192.168.1.11:1433      ESTABLISHED
  TCP    192.168.1.11:3137      192.168.1.11:1433      ESTABLISHED
  TCP    192.168.1.11:3139      192.168.1.11:1433      ESTABLISHED
  TCP    192.168.1.11:3141      192.168.1.11:1433      ESTABLISHED
  TCP    192.168.1.11:3143      192.168.1.11:1433      ESTABLISHED
  TCP    192.168.1.11:3145      192.168.1.11:1433      TIME_WAIT
  TCP    192.168.1.11:3147      192.168.1.11:1433      TIME_WAIT
  TCP    192.168.1.11:3149      192.168.1.11:1433      TIME_WAIT
  TCP    192.168.1.11:4610      207.46.249.56:80       CLOSE_WAIT

=================================================================


Where 192.168.1.11 is my server's ip.

There's lots of port 1433, with both Local Address & Foreign Address the same: my server's ip.

I don't remember there's lots of port 1433 before, is it normal or not?
I'm a amateur WWW site builder.

And Sorry for my poor english .....
Edited by - suona on 08 March 2004 19:14:43

hippojimj
Starting Member

USA
17 Posts
Posted - 08 March 2004 :  19:24:27  Show Profile  Visit hippojimj's Homepage  Send hippojimj an AOL message
Yup, that's the communications with the SQL server... pretty normal.

Jim Jones
Co-Hippo
Hippo Variety
http://www.hippow.com
http://www.auctionmanagement.net
Edited by - hippojimj on 08 March 2004 19:29:12
Go to Top of Page

suona
Junior Member

Taiwan
121 Posts
Posted - 09 March 2004 :  09:04:05  Show Profile  Visit suona's Homepage
Thanks !

If there's hundereds even thousands of port 1433 connection, still normal ?

My web site's maximum online users will not exceed 50.
I'm a amateur WWW site builder.

And Sorry for my poor english .....
Go to Top of Page

pweighill
Junior Member

United Kingdom
453 Posts
Posted - 15 March 2004 :  08:30:54  Show Profile
You should try looking at the connections from within SQL Server.

Run a proc such as sp_who2
to see what database each connection is using.
Go to Top of Page

suona
Junior Member

Taiwan
121 Posts
Posted - 15 March 2004 :  19:05:17  Show Profile  Visit suona's Homepage
Using Enterprise manager--->management--->current activity

there's about 10 connections, including some system database. real client users only 3.

but the same time, using netstat -n, I got 988 lines of port 1433, local & foreign. Divide by two, there's 494 connections.
I'm a amateur WWW site builder.

And Sorry for my poor english .....
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07