"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.
- Is your machine operational 24x7x365, and if it is not
- Have you examined the memory released at re-boot?
- Have you assessed the rate of its accumulation after reboot?
--
Pete Brown
IT Managers & Engineers
Falls Creek
Australia
www.mountainman.com.au/software
Received on Tue Aug 23 2005 - 01:29:52 CDT
