April 30, 2012 at 10:03 am
Our production database server currently has 56GB of installed physical memory. But it has Windows Server 2008 R2 standard Edition on X64bit. So only 32GB of memory is available for use based on the limitations from MS. When I check the properties of the computer it shows that the installed memory is 56GB(32GB is usable). IS there any other way that I can make use of the 24GB of memory that is being wasted? Or did I not get it right?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 30, 2012 at 10:13 am
Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10[1].pdf
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2012 at 1:42 pm
You would need to upgrade Windows to Enterprise Edition, at which time SQL Server would immediately gain access to the additional RAM.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 2:05 pm
GSquared (4/30/2012)
Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10[1].pdf
The OP was talking about Windows Server not SQL Server being the limiting factor the link has the differences. standard edition is limited to 32 GIG of ram. the OP would need enterprise or higher to max out the ram usage for the 56 GIG he has on the server.
http://www.directionsonmicrosoft.com/sample/DOMIS/update/2008/02feb/0208ws2plp_ch.htm
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 30, 2012 at 2:09 pm
capn.hector (4/30/2012)
GSquared (4/30/2012)
Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10[1].pdfThe OP was talking about Windows Server not SQL Server being the limiting factor the link has the differences. standard edition is limited to 32 GIG of ram. the OP would need enterprise or higher to max out the ram usage for the 56 GIG he has on the server.
http://www.directionsonmicrosoft.com/sample/DOMIS/update/2008/02feb/0208ws2plp_ch.htm
OK, I'll play your silly little game 😀
+1
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 7:48 pm
Thanks for your reply. Right now SQL Server max memory setting is set to 25600MB and I want to change it to 29000 as I have ensured that there are no applications running other than SQL Server on this server. But I wanted to make use of the memory that is being wasted.
If upgrading the OS to Enterprise edition is the only solution then I am sure it is wasted (budget constraints).
Thanks for your help guys.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 30, 2012 at 8:29 pm
Sapen (4/30/2012)
If upgrading the OS to Enterprise edition is the only solution then I am sure it is wasted (budget constraints).
What would be the implications on SQL Server when the OS is upgraded to Enterprise Edition. Any precautions that needs to be taken. Just checking as I haven't done this before.
M&M
April 30, 2012 at 8:37 pm
mohammed moinudheen (4/30/2012)
Sapen (4/30/2012)
If upgrading the OS to Enterprise edition is the only solution then I am sure it is wasted (budget constraints).What would be the implications on SQL Server when the OS is upgraded to Enterprise Edition. Any precautions that needs to be taken. Just checking as I haven't done this before.
back up every thing format and reinstall would be the way i would go about the OS upgrade. upgrading may work but a fresh slate will always work.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 30, 2012 at 8:41 pm
Sapen (4/30/2012)
Thanks for your reply. Right now SQL Server max memory setting is set to 25600MB and I want to change it to 29000 as I have ensured that there are no applications running other than SQL Server on this server. But I wanted to make use of the memory that is being wasted.If upgrading the OS to Enterprise edition is the only solution then I am sure it is wasted (budget constraints).
Thanks for your help guys.
Of course take backups and plan a recovery strategy should the Windows upgrade itself go poorly, but in terms of SQL Server it shouldn't be an issue. I would shut down all SQL Server services and have the services Disabled so they do not come back up on their own after reboots, then upgrade the OS, then bring SQL Server up manually after the OS upgrade and any necessary reboots are complete.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 8:43 pm
capn.hector is correct too (we were typing at the same time so didn't see his post)...I do not expect issue with an in-place upgrade, but a fresh slate is always a safe route.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 9:46 pm
Thank you opc\capn for instant reply.
M&M
May 1, 2012 at 6:13 am
capn.hector (4/30/2012)
GSquared (4/30/2012)
Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10[1].pdfThe OP was talking about Windows Server not SQL Server being the limiting factor the link has the differences. standard edition is limited to 32 GIG of ram. the OP would need enterprise or higher to max out the ram usage for the 56 GIG he has on the server.
http://www.directionsonmicrosoft.com/sample/DOMIS/update/2008/02feb/0208ws2plp_ch.htm
Exactly. And no "setting" will change that is my point.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply