Re: Is there any way I can make garbage collection aggressive in SQL 2000 or 2005?

"Nimesh" <nimeshj_at_gmail.com> wrote in message news:1124774316.514411.253590_at_g44g2000cwa.googlegroups.com...
> Thanks for your reply. I know it is behavior of SQL 2000, and it is
> supposed to release the memory when not required. That is why I want to
> make garbagge collection aggressive. Other than this we are also facing
> this problem in Analysis server, this service is consuming more than
> 1.5 GB of memory. And while the cube in the process mode, it becomes
> very very slow to get the data. We are also trying to optimize the
> cube. How to Optimize the cube in SQL 2005?
> But my primary query is, is there any way by which we can make garbage
> collection aggressive in SQL 2000. Please let me know if any one knowa
> how to do it?

If it is a matter of survival I'd be asking the following questions.

1. Is your machine operational 24x7x365, and if it is not
2. Have you examined the memory released at re-boot?
3. Have you assessed the rate of its accumulation after reboot?

-- 
Pete Brown
IT Managers & Engineers
Falls Creek
Australia
www.mountainman.com.au/software