Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLSERVER Mem usage
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
00981381
Message ID:
00981395
Vues:
42
Marc,

What are you using to access VFP data: VFP ODBC, VFP OLE DB? What version? Are you reading from or writing to VFP tables?

>
>I have a big problem with my SQL Server 2000 SP3a runing on Windows server 2003. When I use Openquery() with a linked server using .DBF table, the amount of Mem Usage in taskmanager for process sqlservr.exe is growing fast and never go down. After restarting SQLServer and 15 Openquery() request, mem usage pass from about 19,000K to about 510,000K. When Mem usage is about 800,000K the server doesn't respond anymore, connections are disconnected and the only way to use it again is restart the service.
>
.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform