Concern for open ports

when i do a netstat i get Rem Port Process CountOfRem Port
ms-sql-s System 193
it seems ms-sql-s is taking up 193 ports ? is this a problem? it seems
excessive.ms-sql-s is using one port (1433) and 192 (193-1) clients
are connected to sql server on that port. Though this kind
of behaviour is possible on a heavily used server, if one
client is using many connections then you should configure
the client application to use connection sharing/pooling.
Output of netstat command will show you who is connected
to the sql server.
192 open connections on a single port is a high number for
tcp layer and for sql server, using connection pooling
will reduce the number of active connections to this
port, and will have positive effect on application as well.
>--Original Message--
>when i do a netstat i get Rem Port Process CountOfRem
Port
> ms-sql-s System 193
>
>it seems ms-sql-s is taking up 193 ports ? is this a
problem? it seems
>excessive.
>
>.
>