>>>>>>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.
>>
>>The customer sent me an email indicating that the server (hosting SQL Server) has 8 GB. And the value in the Maximum memory is 2147483647 MB. Does it mean they have no limitation? Or, should the Maximum memory number should be changed to?
>
>
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16Thank you!
"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