February 9, 2016 at 11:24 am
Microsoft technet web page states that the AWE memory option will be removed in "the next version" of Microsoft SQL Server.
We have two 32 bit servers running SQL 2008 R2 RTM on Windows Server 2003 (one of them) and Windows Server 2008 (the other), and both have AWE enabled. We want to upgrade these to SP3 of 2008 R2. The Upgrade Advisor says this needs to be removed before we upgrade.
Is this "next version" 2008 R2 SP3, or SQL 2012? Due to application issues cannot yet go to 2012 or 2014.
Any thoughts on what will happen when we upgrade?
I may end up turning it off, bouncing the server, doing the upgrade, then see what happens when I turn it back on after the upgrade.
Thanks in advance for any thoughts!
February 10, 2016 at 1:58 am
"Next version" always means next major version, not next service pack.
Upgrade advisor is for upgrading major versions (eg to 2012 or 2014), it doesn't check anything regarding applying service packs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply