This problem is driving my crazy. I have set up a small LAN to test SQL Server 7.0 performance. Here is a subset of the relevant hardware:

Server:
Compaq Proliant 1600R 2 (yes 2) PIII 550, 20GB Wide Ultra SCSI Drives (Mirrored), 512MB RAM. The server cooks under ALL circumstances.

Network:
Intel 410T Switch (all devices running at 100MB)

Workstation:
Compaq Professional Workstation PIII 500 w/256 MB Ram.

I transferred a 50 MB file to the server. I found that the only way to do this was by installing VFP on the SQL Server machine and running the upsizing wizard directly on that machine. Running it from the workstation took 5 hours to upsize 10% of the table. Running the upsize wizard directly on the SQL Server only took about 5 minutes.

I then ran a few queries. Using SQL Passthrough, I can retrieve a single record with a simple query in under a second. This same query takes over 10 seconds on the workstation.

I then created a remote view on a single table using a single where condition. This query takes less than a second when run from the SQL server, yet takes over 10 seconds on the workstation.

Anyone have any idea why SQL commands execute so slowly from the workstation? It is not due to problems with hardware, etc.

Thanks in advance