Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Process that used to take 45 minutes now takes over 12 h
Message
 
To
24/09/2013 16:30:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01584030
Message ID:
01584058
Views:
91
>Hello all.
>
>Andy is on a VFP to .NET and SQL Server conversion project. He is using VFP to migrate the data into SQL Server. The process to push the VFP data into SQL Server used to take about 45 minutes and he has been running this code for over a year. All of a sudden, for no apparent reason, the process has come to a screeching halt and is taking over 12 hours to run. Andy did not change any of his code, so it has to be something else like a Windows update.
>
>Does anyone have any ideas?
>
>TIA.
Check this. It wouldn't tell you what is the problem, but will help you to find it out.
Correlating SQL Server Profiler with Performance Monitor
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform