Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Process that used to take 45 minutes now takes over 12 h
Message
 
À
24/09/2013 16:30:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01584030
Message ID:
01584058
Vues:
89
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform