Forums

Administration & IT Memory allocation on SQL 2008 R2 SP1

Memory allocation on SQL 2008 R2 SP1

John Brandt $organization over 14 years ago

Hello,

We have a virtual box Windows 2008 and SQL 2008 R2 that is using 97% physical memory. It has 8gb. Is this right? Can I tweak it to perform better?

Thanks

John

Christian Carranza $organization over 14 years ago

If I recall correctly, RAM usage will always be high on an MS SQL Server, as SQL Server will load as much of the database as possible into RAM to act as a cache. To wit:

http://serverfault.com/questions/182559/sql-server-memory-constantly-going-up-from-1gb-ram-used-to-7gb-in-a-week

CC
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
John Brandt $organization over 14 years ago in reply to Christian Carranza

Thanks the article makes sense. We will watch it. We have been concerned because we have been seeing system memory errors in the log files.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel