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



It is not very urgent but we need to find out the cause and solve if
possible:
1. Yes, this machine is operational 24*7*365. But we do reboot this
server once in week (Every sunday morning) for backup and to clear
memory.
2. Yes, we have examined the memory release. And it does get release
after re-boot.
3. Yes, we have accessed the rate of accumulation after reboot and
re-start of the service. After reboot/restart the Analysis service
cosumes 150 MB and after a day 400 MB, and after a week if the service
is not restarted it reaches at round 1.5 GB. Do not know why this
happening. We want to findout the cause of this. And possible solution.

.



Relevant Pages

  • Re: Random reboots with M2N-E (even worse now)
    ... error that happens during the reboot, ... I've known memory beeps to be 3 short ones, but this is on the Award ... When I couldn't find the 2.1V setting in the BIOS to adjust the memory ... you should get the same beep code. ...
    (alt.comp.periphs.mainboard.asus)
  • Re: Weird XP Start-Up Problem - Please help!
    ... but a while ago we built a number of PCs with gigabyte motherboards and I can't remember what memory but after XP was installed the following day a number of these PCs didn't boot, they blue screened but after that each PC started perfectly ran every test we could think of and nothing. ... Seems crazy and even telling the customer to hold the power button for a second longer when switching on they looked at me crazy but it worked.. ... CHECKING FILE SYSTEM ON D: ... reboot I get the standard "Sorry for the inconvenience" screen to ...
    (microsoft.public.windowsxp.general)
  • Re: Weird XP Start-Up Problem - Please help!
    ... Debi :-) ... problem with the memory starting up correctly. ... new memory in) to hold the power button for a second longer when switching ... reboot I get the standard "Sorry for the inconvenience" screen to ...
    (microsoft.public.windowsxp.general)
  • Re: Gateway reset on reboot (was: xnptd insane after reboot) *SOLVED*
    ... TCP/IP with no physical memory available. ... The reboot would have scrubbed ... network came right back. ... Dave Stewart ...
    (AIX-L)
  • Re: Random reboots with M2N-E (even worse now)
    ... I don't even get into windows. ... error that happens during the reboot, ... I've known memory beeps to be 3 short ones, but this is on the Award ... When I couldn't find the 2.1V setting in the BIOS to adjust the memory ...
    (alt.comp.periphs.mainboard.asus)