Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL performance question
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
SQL performance question
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01352907
Message ID:
01352907
Vues:
78
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform