>>>Hi,
>>>
>>>I have a customer using my VFP9 application with a SQL Server database. They report to me that the application (VFP9) becomes slower overtime and they found that, after rebooting the SQL Server, the application runs faster.
>>>Is there something I can do within the application?
>>>Is there a SQL Server temporary log that is being created (by SQL Server) they may gets cleared when they reboot the server?
>>>Please let me know if you have any other suggestions.
>>>TIA
>>
>>If there is no limitation of memory SQL Server could use that after a while it will take over ALL memory of the server.
>
>Please, allow me to ask for some clarification. Is there anywhere in SQL Server where the 'no limitation of memory is set'?
>And if/when all memory of the server is taken by the SQL Server, does it mean that the SQL Server stops working?
Check the picture I attached. This is no Limitation.
And you sometime the whole system can stop.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.