Hi and thank you for looking
Here's my problem: we have SQL server 7.0 running on a Dell server, with
1GB of ram. Lately, some consultants began to install reports available
through our intranet by using synergy and cold fusion. They did complex
reports that used many queries at a time. However it seems that whenever
they run a nested query or many queries to display a report, the memory used
by the server is not released.
If I am looking at the task manager, I can see that whenever they execute a
report, the memory goes up, sometimes some of it is released but not always.
The server has 1GB of memory, and in the SQL server settings I changed the
'available memory to use' to max 800 mb, but it still doesn't release it
after. The transaction log is set at 750 mb, but if I look at it it's not
even one third in use, and the option 'truncate log on checkpoint' is
We are now at a point where we must reboot the server several times a day,
and it is becoming quite frustrating. Is there any setting or temporary
tables we could change ?
Thank you for your time,