Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL performance question
Message
From
06/10/2008 01:22:24
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Client/server
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:
01352908
Views:
22
Any virusscanner running locally... if so, try turning off


>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform