High RAM usage Memory Leak? MrSlep 3/6/2007 4:26:47 PM I'm running Outlook w/ Business Contact Manager....and SQLservr is currently taking 840MB of RAM (after sitting idol overnight). It seems there is a memory leak -- as Business Contact Manager runs RAM usage continues to increase. Is anyone else having this problem?

Re: High RAM usage Memory Leak? "Clinton Ford [MSFT]" <ClintonFordMSFT[ at ]discussions.microsoft.com> 3/6/2007 7:52:20 PM SQL Server is designed to consume free memory to improve performance. It will release the memory after a while if no inbound connections are received. SQL Server will also free memory when the Operating System notifies applications that it is low on memory. Are you running into any specific problems due to low system memory? -- Visit team blog at http://blogs.msdn.com/bcm This posting is provided "AS IS" with no warranties, and confers no rights "MrSlep" <MrSlep[ at ]discussions.microsoft.com> wrote in message news:CA930B79-5F87-4C4B-BD30-792CEEF86692[ at ]microsoft.com... I'm running Outlook w/ Business Contact Manager....and SQLservr is currently taking 840MB of RAM (after sitting idol overnight). It seems there is a memory leak -- as Business Contact Manager runs RAM usage continues to increase. Is anyone else having this problem?

Re: High RAM usage Memory Leak? MrSlep 3/7/2007 3:13:02 AM I left Outlook with contact manager open over night. By morning it was consuming over 800mb of RAM. The computer was not being used at all. It seems something is causing it to continually increase the RAM usage. I have 2G of RAM so I am not running out of memory...but sqlsevr.exe alone is consuming nearly 50% at times. "Clinton Ford [MSFT]" wrote: [Quoted Text] > SQL Server is designed to consume free memory to improve performance. It will release the memory after a while if no inbound > connections are received. SQL Server will also free memory when the Operating System notifies applications that it is low on > memory. > > Are you running into any specific problems due to low system memory? > -- > Visit team blog at http://blogs.msdn.com/bcm > This posting is provided "AS IS" with no warranties, and confers no rights > "MrSlep" <MrSlep[ at ]discussions.microsoft.com> wrote in message news:CA930B79-5F87-4C4B-BD30-792CEEF86692[ at ]microsoft.com... > I'm running Outlook w/ Business Contact Manager....and SQLservr is currently > taking 840MB of RAM (after sitting idol overnight). It seems there is a > memory leak -- as Business Contact Manager runs RAM usage continues to > increase. > > Is anyone else having this problem? > > > > > >

Re: High RAM usage Memory Leak? "TechSoEasy" <TechSoEasy[ at ]gmail.com> 3/12/2007 9:46:57 PM On Mar 6, 12:52 pm, "Clinton Ford [MSFT]" <ClintonFordM...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > SQL Server is designed to consume freememoryto improve performance. It will release thememoryafter a while if no inbound > connections are received. SQL Server will also freememorywhen the Operating System notifies applications that it is low onmemory. > > Are you running into any specific problems due to low systemmemory? > -- > Visit team blog athttp://blogs.msdn.com/bcm > This posting is provided "AS IS" with no warranties, and confers no rights"MrSlep" <MrS...[ at ]discussions.microsoft.com> wrote in messagenews:CA930B79-5F87-4C4B-BD30-792CEEF86692[ at ]microsoft.com... > > I'm running Outlook w/BusinessContactManager....and SQLservr is currently > taking 840MB ofRAM(after sitting idol overnight). It seems there is amemoryleak-- asBusinessContactManagerrunsRAMusagecontinues to > increase. > > Is anyone else having this problem? I've continued to have this problem and while I totally understand the nature of SQL consuming additional RAM as it needs and releasing it (similar to Exchange, I would think), I totally couldn't understand why my BCM's database would consume as much as 800MB of RAM in addition to 1.5GB of my virtual memory. With Exchange, I've found that this would happen if the Antivirus program was scanning the Exchange Databases, and excluding them would significantly lower the RAM usage of the store.exe process. So I followed the same logic with BCM's SQL DB's and sure enough, the memory usage plummeted. Although the virtual memory remained high... I can live with that! Jeffrey B. Kane TechSoEasy San Francisco, CA http://www.techsoeasy.com

Re: High RAM usage Memory Leak? "Luther" <enowning[ at ]gmail.com> 3/14/2007 7:19:44 AM On Mar 12, 2:46 pm, "TechSoEasy" <TechSoE...[ at ]gmail.com> wrote: [Quoted Text] > On Mar 6, 12:52 pm, "Clinton Ford [MSFT]" > > <ClintonFordM...[ at ]discussions.microsoft.com> wrote: > > SQL Server is designed to consume freememoryto improve performance. It will release thememoryafter a while if no inbound > > connections are received. SQL Server will also freememorywhen the Operating System notifies applications that it is low onmemory. > > > Are you running into any specific problems due to low systemmemory? > > -- > > Visit team blog athttp://blogs.msdn.com/bcm > > This posting is provided "AS IS" with no warranties, and confers no rights"MrSlep" <MrS...[ at ]discussions.microsoft.com> wrote in messagenews:CA930B79-5F87-4C4B-BD30-792CEEF86692[ at ]microsoft.com... > > > I'm running Outlook w/BusinessContactManager....and SQLservr is currently > > taking 840MB ofRAM(after sitting idol overnight). It seems there is amemoryleak-- asBusinessContactManagerrunsRAMusagecontinues to > > increase. > > > Is anyone else having this problem? > > I've continued to have this problem and while I totally understand the > nature of SQL consuming additional RAM as it needs and releasing it > (similar to Exchange, I would think), I totally couldn't understand > why my BCM's database would consume as much as 800MB of RAM in > addition to 1.5GB of my virtual memory. > > With Exchange, I've found that this would happen if the Antivirus > program was scanning the Exchange Databases, and excluding them would > significantly lower the RAM usage of the store.exe process. So I > followed the same logic with BCM's SQL DB's and sure enough, the > memory usage plummeted. Although the virtual memory remained high... > I can live with that! > > Jeffrey B. Kane > TechSoEasy > San Francisco, CAhttp://www.techsoeasy.com It might be the Windows Search engine that's querying the BCM database while the machine is otherwise idle. That memory should get released, or at a minimum paged to disk, when other applications ask NT for memory.