>>>>>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-ver16