It’s Just Poison…

I had added a bunch more RAM to my database server (MS SQL 2005) and it eatted it all up! This isn’t an exaggeration either. It consumed every little byte! So my question… why?

After a lot of hair pulling and then a little googling, I found my answer. By default SQL 2005 consumes all available memory. Not cool. To set a limit, just open up the SQL Design Console and Right click on the server instance, then choose Properties. You’ll see a Memory tab on the left. In there you can set it to use min / max MB of RAM.

After I updated it to 512 less than what I had, my server ran much smoother. The problem was that SQL would eat up all the available ram and then not give any back to other apps and services that needed it to run properly.

Fook!

Tags: Database //