Configuring SQL Server 05 for More than 2GB

Forum Moderators: open

Message Too Old, No Replies

Configuring SQL Server 05 for More than 2GB

Only using 1.7 GB

woop01

2:11 am on Oct 16, 2006 (gmt 0)

We just got a new box with 8 GB of RAM running SQL Server 2005 Standard Edition.

When I view task manager, SQL Server is only using ~1.7 GB of memory. Does this mean it's not using all the RAM it can or am I confusing what that means? How do I make SQL Server use more memory?

I've assigned the "Lock Pages.." priviledge to the account running SQL Server and set the AWE option to 1. I'm not sure what else I need to do.

FalseDawn

5:54 pm on Oct 17, 2006 (gmt 0)

Windows memory management is different to linux - apps in windows will only use the memory they need, often leaving a big chunk unused.
If SQL Server is only using 1.7GB, then it's highly likely that it doesn't actually need any more!

In linux, the memory is usually fully allocated at all times.

FalseDawn

5:59 pm on Oct 17, 2006 (gmt 0)

The following might be relevant, though:
[support.microsoft.com...]

Especially the note someway down about consulting SQL Server 2005 books online regarding accessing >2GB of memory.

[edited by: FalseDawn at 5:59 pm (utc) on Oct. 17, 2006]

woop01

8:22 pm on Oct 17, 2006 (gmt 0)

That was actually the first article we checked.