I have a remote app, that is using Access 97 to run, and runs on a virtual RDS server. It is accessing a SQL 2005 x64 database on a separate virtual server. When I run a search through the remote app, it takes 60-120 seconds to respond. When ran locally on the SQL server, it takes 30 seconds. I have worked with the software vendor and they think it might be an issue with the ODBC connection going across the hypervisor. Any thoughts?
I thinks that is strange.
Can you reproduce in a physical environment?
Which kind of virtual adapter are you using? Have you put both VMs on the same host?