>>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?
"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
