Need to flush sqlservr.exe process through an automatic task

Hey there, I have a client running SQL 2005 and ACT Premium 2010.  There is a SQLSERVR.EXE process that is gradually growing in size, as the database is used (there are only 4 people using it in the company).  It seems that the requests are not flushing or releasing after being processed and lumping itself into the RAM.  It starts around 200MB and grows to 1.4GB before the server becomes so slow, it needs to be restart or I have to restart the SQLSERVR.

Having a tast to restart SQLSERVR.exe is not hard, however there are a bunch of dependant ACT modules that need to be restart after SQLSERVR is restearted.

I know this is chasing the symptom, but neither SAGE or the custom DB guys supporting the ACT stuff will fess up to where the issue is coming from.

Is there any way to 'flush' the sqlserve.exe process lets say at midnight without doing a restart of the process (so it does not cause issues needing them to all be restart manually again)

Thank you
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Start | Run | ACTDIAG
Tools | Release ACT! Memory

You can set how often you want it to run
bcameron70Author Commented:
GLCOMPUTING...I tried the ACT memory release, but ides not seem to affect the sqlservr.exe process...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.