High RAM usage Memory Leak?

[MrSlep]

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?

 

[Clinton Ford [MSFT]]

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
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?

 

[MrSlep]

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.

 

[TechSoEasy]

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

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

 

[Luther]

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.