>>>>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.
Thank you very much! I will ask the customer IT what they have in this setting.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham