I have a SQL Server 7.0 (now upgraded to SP4) on Windows 2000 Adv. Server, dual procs. It seems when I execute a simple query from any client (Query Analyzer) (i.e. Select * from table - has 6200 rows) It takes anywhere from 45secs -2 mins to return all rows. Directly from the server it takes 7-10 seconds. I checked the following:
Made sure Named Pipes & TCP/IP were enabled
Entered a client connection for TCP/IP, and Named Pipes, separately on the client PC, tried other clients too.
Ran query w/ & w/o idx - barely a difference
Used query idx hint - no difference
Finally, on this site, I found a possible bug explained as this:
(After some invetsigation we found a BUG (ID: Q308016)when you use SQL 7.0 with DB-LIBDARY client the "Network Packet Size" is '512' instead of what has been configured on SQL Server. We have contacted Microsoft and received/applied the in our test environment and noticed the performance improvement. )
However, I applied SP4, rebooted, and still the same performance. This is unacceptable. I am ready to rule this a H/W - Network issue. Any other ideas? Please comment! Many thanks.