6G Ram but SQL doesn't make use of it by default

If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
I have made a new fresh setup (everything is in 64 bit version) on a brand
new machine with 6Gigs of RAM, still when I display server's properties, in
the memory section, in the textbox under Max Server memory
I have 2147483647, which I think is 2 G
Thanks
You shouldn't have to do any config on a 64 bit SS on a 64 bit machine for using > 2GB memory.

> I have 2147483647, which I think is 2 G
No, that number is in MB:
2147483647 MB
= 2097151 GB
= 2047 TB
= approx 2 PB (it is Peta or Exa?)
No discussion on memory and 64 bit is complete without referring to Slava Oks blogs. In short,
consider using lock pages in memory also on 64 bit (if my memory serves me):
http://blogs.msdn.com/slavao/archive/category/9043.aspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties, in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks
|||2147483647 is much more than 2GB... 1024 = 1GB
Keith Kratochvil
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties,
> in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks
|||Hi Salam,
As other members have mentioned, the 2147483647 default value is in MB, so
it is a quite large value( you need to reduce it according to your
machine's physical memory).
As for AWE, it is an operating system feature and is only useful when the
virtual address space(of OS process) is less than the available physical
memory. For SQL server 2005 64 bit on windows 2003 64 bit, there is no
such virtual address space limitation(normally virtual address space is
much larger than available physical memory space). also, it is recommended
that we adjust the SQL Server instance's max server memory to a proper
value so that other applications on the server can also get sufficient
physical memory for paging file switch.
#Enabling AWE Memory for SQL Server
http://msdn2.microsoft.com/en-us/library/ms190673.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Salam,
Have you got any further idea on this issue? Please feel free to post here
if there is anything else we can help.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.