.NET & SQL connections "TIME_WAIT"
Hi,
Our company developers have implemented a .NET v2 website that
connects to a backend SQL2000 db through a firewall [DMZ >>>> LAN].
All the non .NET apps seem to be pretty quick but for some reason
the .NET2 application is very slow over the inetrnet and even locally.
When I run netstat on the IIS box I see around 60 entries like this
TCP IISSERVERNAME:4501 db_ghlplc:ms-sql-s TIME_WAIT.
On the backedn SQL server the same entries exist but not as many and
Enterprise manager tells me we have only 11 connections [Pooling is on
and working]. Can anyone tell me why I would have so many TIME_WAIT on
the IIS and if that would indeed be slowing down the .NET2 app?
Both servers run on Windows Server 2000 and only traffic that is
allowed form DMZ>>>LAN is port 1433.
Regards
G
Date:Wed, 08 Aug 2007 09:34:37 -0000
Author:
|