Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Is there any way I can make garbage collection aggressive in SQL 2000 or 2005?

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

From: mountain man <hobbit_at_southern_seaweed.com.op>
Date: Tue, 23 Aug 2005 06:29:52 GMT
Message-ID: <AnzOe.7829$FA3.3710@news-server.bigpond.net.au>


"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
Received on Tue Aug 23 2005 - 01:29:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US