September 7, 2007 at 10:27 am
Hi all,
We have a server with Windows 2003 SP2 and IIS6. We have a server with Windows 2003 SP2 and SQL 2000 SP4.
I run a query directly on the SQL box, it takes 30 seconds. Running it from the IIS6 server in an ASP page the same simple select query takes 7 minutes if we up the timeout.
Clearly this is terrible. We have a firewall between the IIS6 server and SQL server but this is all configured correctly (apparently) by our network firm.
Can anyone think of any SQL server settings that could be causing this issue? I can't see any problems and it is all configured the same as our other server setup which is the same but minus the firewall in between.
Thanks for your help!
September 7, 2007 at 12:00 pm
Consider you ASP page, could be something wrong in it.
If it were the firewall more than likely you woulkd never get data, firewalls generally don't cause slowdown in connection, just no connection at all. So I would start at the code itself as to how it retreives and displays the data.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply