Memory leakage

Question

Memory leakage

charipg

SSCrazy Eights

Points: 9888
More actions
June 11, 2010 at 2:24 pm

#143582

I have noticed Memory leakage in the datatbase .
Each time I run the Performance test, minimum of 100 MB of Physical memory is consumed by the application and it is not being released after the test.
Also, I want to know the causes of it. I know Application code can cause memory leakage. Is there any other way that the memory leakage happen in DB Server?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

Your SQL Server database instance will reserve memory as it needs it. Once the memory has been reserved, it will not release it. It keeps it for buffer space for data, procs, execution plans, etc. You want your DB to keep control of as much memory as it can. The DB instance performs better with more memory.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

nabidavid SSC Eights! Points: 815 More actions · Answer 2

If you are referring to "memory leaks" in a SQL Server instance, SQL Server will acquire system memory over time, but it will not release the memory unless requested by the operating system. This functionality is by design to improve performance. SQL Server will continue to reuse the allocated memory space for future operations.

If you are concerned about the amount of memory the server uses, you can always limit it in the instance's settings.

Also, restarting the SQL Server service will free system memory as well, but obviously, you shouldn't restart a production server during normal business hours. 😉

charipg SSCrazy Eights Points: 9888 More actions · Answer 3

Can you please let me know how do we free up the memory and how frequently you do that?

John Rowan SSC Guru Points: 56440 More actions · Answer 4

charipg (6/11/2010)
Can you please let me know how do we free up the memory and how frequently you do that?

Why would you want to free up the memory? Your database instance will perform better with more memory allocated to it. You should run your SQL Server instance on a dedicated machine so there is no other processes competing for resources.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Nils Gustav Stråbø SSChampion Points: 11259 More actions · Answer 5

Are you running low on memory? Experiencing any performance problems? Unused memory is wasted memory... except that it is good to have some left for unexpected memory needs.