October 26, 2009 at 6:48 am
Hi,
we're running SQL Server 2008 Standard edition on Windows Server 2003 Enterprise Edition, 32 bit with 12 GB RAM.
It's a dedicated SQL Server machine.
I recently configured the SQL server to allocate memory through AWE. Since I had read that the Standard edition can only use a max of 4GB RAM, I didn't bother to set a max value (default value is still there ~2000 TB)
When running "dbcc memorystatus", the server now reports "AWE Allocated = 10420224 KB"
So, my questions are:
Was I wrong not to specify a max value?
Can the Standard edition really use 10GB RAM?
And another related question, presuming that it really only can use 4GB of memory (and the rest is just allocated for whatever reason), is there a possibility that we could benefit from running two clustered instances of the standard edition on the same machine (since it has 12 GB RAM)?
Very grateful for any help or input.
Kristofer
October 26, 2009 at 8:19 am
It is the Workgroup edition that is 4gig max ram in SQL Server 2008 it was 3gig max ram in SQL Server 2005, the standard is OS max ram since SQL Server 2005. I will not comment about clustering because the standard can use all the ram without any switch.
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
Kind regards,
Gift Peddie
October 26, 2009 at 9:28 am
Wow, that's good news. Damn, next time I'll make sure to double check my facts... :pinch:
I guess I'd better set that max value then.
Thanks for your help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply