Memory Usage from sql server.

Hi, I have a server that has sql server2000 sp3 on win2000 server sp4.
On this server every day runs a process that take about 3 minutes to
finish. But once a month it takes about 30 min. or one hour to finish.
At this moment the only thing that help us to fix the problem is to
restart the server, so we have to restart the server almost once a
month.
Today, we were thinking if maybe the memory of the server is not been
freeing so, it is not enought and it has being free when the server is
restarted.
Do somebody know if sql server has some command that can help us to free
the memory or to check if this is busy and avoid to restart the server.
I'll apreciate a lot your help.
Regards,
*** Sent via Developersdex http://www.developersdex.com ***My guess would be that you have other apps running onthe server and don't
leave enough for them to operate properly. If so try setting your max
memory setting to a few hundred MB less than the max and see if that helps.
YOU should also check for blocking during that time.
--
Andrew J. Kelly SQL MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uJ$rY9MMGHA.2916@.tk2msftngp13.phx.gbl...
> Hi, I have a server that has sql server2000 sp3 on win2000 server sp4.
> On this server every day runs a process that take about 3 minutes to
> finish. But once a month it takes about 30 min. or one hour to finish.
> At this moment the only thing that help us to fix the problem is to
> restart the server, so we have to restart the server almost once a
> month.
> Today, we were thinking if maybe the memory of the server is not been
> freeing so, it is not enought and it has being free when the server is
> restarted.
> Do somebody know if sql server has some command that can help us to free
> the memory or to check if this is busy and avoid to restart the server.
> I'll apreciate a lot your help.
> Regards,
>
> *** Sent via Developersdex http://www.developersdex.com ***