Target Memory Problem

Question

I have a server like the following:

Windows Server 2003 installing SQL 2008R2 SP1

with 1GB physical memory

No matter what I set to the MAX Memory setting in SQL server. The Target Memory is only around 400MB.

are there any problem?

Answer 1

Keep in mind that SQL Server needs to play nice with the OS and other applications running on the server so a 400MB target is reasonable on a 1GB machine.

---

Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

Answer 2

Check out below link.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/1e51965d-fbb1-4f73-b977-5284516b3d45/

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 3

Target memory indicates the ideal amount of memory the server can consume. You need to look at other counters as well before pin point memory issue. Link in Ahmed's reply gives more info. Simply looking at this can not see problem.

Answer 4

Just adding to above responses, most of the Edition of SQL Server 2008 R2 recommends 4 GB RAM. You may refer to Hardware and Software Requirements for Installing SQL Server 2008 R2.