Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL performance question
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL performance question
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01352907
Message ID:
01352907
Views:
77
I need help figuring out why access to data in a SQL Server 2005 database is suddenly abysmally slow on my local workstation. The same code running against identical data is at least 25 times faster over a Remote Desktop connection!

About 10 days ago I ran scripts that convert VFP free tables to the SQL database the client's application uses. I copied the resulting database to the client’s server. Their installation runs as it always has, but mine is now miserably slow.

About the same time, and without a conscious choice on my part, Windows Update installed XP SP3. I don't know if this app's slowness is related or not. I don't see threads here or elsewhere about slowness after installing XP SP3. (It seems like everything is slower lately but I can't prove that.) I've culled through all of the "Services" that are running--many were changed by SP3--but don't see any obvious culprits. Have others had problems with SP3?

I took the workstation off the network and ran the application without a firewall and there was no improvement in performance.

Any suggestions how to troubleshoot this would be appreciated.
Next
Reply
Map
View

Click here to load this message in the networking platform