Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tripodal
Constraint Violating Yak Guru
259 Posts |
 Posted - 2010-01-22 : 11:48:16
|
| I have the awecome problem of every outgoing port being consumed. 1025-5000. 99.5% of them are connecting to a SQL Server of mine.My latest huncch is that connection pooling is not being used, and the default 4 minutes time_wait wont cut it for 1000's of connections per minute for this website.Has anyone else seen something similar?netstat -an looks similar to this.c:\netstat -anTCP 10.0.0.1:1025 10.0.0.2:1433 TIME_WAITTCP 10.0.0.1:1026 10.0.0.2:1433 TIME_WAIT...TCP 10.0.0.1:5000 10.0.0.2:1433 TIME_WAIT[lsass.exe]Think I am on the right track? My dev's code is all powerful. Convincing them its wrong is not easy. |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2010-01-25 : 12:44:34
|
| I have successfully proven there is something odd in the code of this website. (I stopped it and the time_waits all went away)Started it and they all came back after a minute or so. My inclination is connection pooling is not working. Unfortunatly for me, this is now an asp question. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Time_Wait