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

> is not restarted it reaches at round 1.5 GB. Do not know why this
> happening. We want to findout the cause of this.

Have you had a look at the performance monitoring of the memory by using the peformance monitoring tool available within SQL server?

There are 29 different parameters associated with the memory management available for monitoring.

If you go through them you will probably find more information about the specific problem you are experiencing.

You can run the perfomance monitor for all these 29 different memory parameters in the background for a test period.

The cause (or causes --- multiple problems are common enough) should be narrowed by this review.

> And possible solution.

Will depend upon the cause(s).

Look at the exercise as a series of steps, the initial one being hunting and gathering of information associated with your
machine memory management.

Good luck.

-- 
Pete Brown
Falls Creek
OZ
www.mountainman.com.au