Query delay from ODBC / IIS / Server 2008

  • We are attempting to upgrade our web servers to IIS7 on Server 2008.

    On our Windows 2003 server, everything runs perfectly fine.

    However, when connecting to our SQL Server 2000 database via ODBC on our 2008 server, there is about a 5 second delay when executing any SELECT statement in our classic ASP code. I ran a trace on our SQL server, and I see the 5 second delays between queries. There is no delay on the SQL server side. It appears that there is some sort of delay on the client side getting these queries to SQL server.

    We have also seen this behavior when using Query Analyzer on our Windows 7 workstations connecting through the Cisco VPN client. Every SELECT is delayed by about 5 seconds before the results are returned to Query Analyzer.

    The strange thing is that doing UPDATEs or INSERTs are executed very quickly.

    Is there anything that has changed with Windows 7 or Server 2008 that implements additional security measures -- ie, are there any auths or lookups or anything that are done each time a SELECT query is performed that could be getting blocked or timing out, etc.? We have checked packed through our firewalls and cannot see anything that needs to be passed through to the server.

    Unfortunately, the ODBC logging on our 2008 server does not work so I can't see what's happening from the web server's side.

    Does anyone have any ideas? Anything would be appreciated, as we have been pulling our hair our for months 😉

    Thanks,

    Jim

  • Still no solutions on our side. Looks like we are just going to upgrade to SQL Server 2008. Maybe its Microsoft's way of saying its time to give us a few more $$.

    If anyone has seen this before, I'd still love to hear what it could be.

    Thanks! Jim

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply