mssql tcp
| From: | Joakim Ling | Date: | Mon, 14 Nov 2005 16:06:22 +0000 |
| Subject: | mssql tcp | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-26480@lists.php.net to get a copy of this message | ||
Hi
When I connect to my MSSQL server (internal) with mssql_connect, make a
few queries etc and then close the connection link. It creates a TCP
connection each time (for every query). I'm running Win 2003 STD, IIS6,
PHP5, MSSQL2000. The problem is that the connection doesn't close
correctly so after a few minutes I will have a lot of TCP connections
that looks like this:
(With "netstat -ap tcp")
TCP w1new:22953 w1new:ms-sql-s TIME_WAIT
TCP w1new:22954 w1new:ms-sql-s TIME_WAIT
TCP w1new:22955 w1new:ms-sql-s TIME_WAIT
TCP w1new:22956 w1new:ms-sql-s TIME_WAIT
TCP w1new:22957 w1new:ms-sql-s TIME_WAIT
TCP w1new:22958 w1new:ms-sql-s TIME_WAIT
TCP w1new:22959 w1new:ms-sql-s TIME_WAIT
TCP w1new:22960 w1new:ms-sql-s TIME_WAIT
TCP w1new:22961 w1new:ms-sql-s TIME_WAIT
TCP w1new:22962 w1new:ms-sql-s TIME_WAIT
TCP w1new:22963 w1new:ms-sql-s TIME_WAIT
TCP w1new:22964 w1new:ms-sql-s TIME_WAIT
TCP w1new:22965 w1new:ms-sql-s TIME_WAIT
After rebooting and running a few minutes the list is full and Windows
begins to act really strange, not so strange when mssql has more then
10000 TIME_WAIT connections waiting to close, but how to close them????
mssql_close(); has no effect to this problem.
I changed the TCPTimeWaitDelay value to 30 in regedit to increase
connections, but still a huge problem. Anyone experience this before or
knows if converting to ODBC would work better?
Best regards
Joakim Ling