October 30, 2009 at 1:33 pm
Just to clarify. If you're using 64-bit SQL Server it is recommend that Lock Pages in Memory be enabled and that the AWE enabled switch be set. This blog entry explains it pretty clearly.
http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx
"Beliefs" get in the way of learning.
October 30, 2009 at 8:51 pm
64 bit seems to have many advantages over 32.
What exactly is the formula to calculate the max GB Ram - physical memory in 32 and 64 bits with AWE? (2 to the power of ?)
October 31, 2009 at 3:29 pm
Robert Frasca (10/30/2009)
http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx%5B/quote%5D
another very good ref is: "Lock Pages in Memory ... do you really need it?" http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx
- http://blogs.msdn.com/slavao/archive/2005/08/31/458545.aspx
- regarding max supported RAM : http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
-- http://technet.microsoft.com/en-us/library/cc758523%28WS.10%29.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 20, 2009 at 1:09 pm
if your on a 64 bit system, and 64-bit SQL, you don't need to worry about any of this AWE, "lock pages in memory" stuff. 64-bit is made to use all the memory you can throw at it without all the hoops you have to jump through to get a 32-bit system to use the extra RAM.
As far as the "if" you should go to 64-bit? YES. The benefits outweigh the risks ten fold.
November 20, 2009 at 1:33 pm
Eddie Hendrix (11/20/2009)
if your on a 64 bit system, and 64-bit SQL, you don't need to worry about any of this AWE, "lock pages in memory" stuff. 64-bit is made to use all the memory you can throw at it without all the hoops you have to jump through to get a 32-bit system to use the extra RAM.As far as the "if" you should go to 64-bit? YES. The benefits outweigh the risks ten fold.
If only it was as black and white as you say it is. Suggest you read some of the comments and follow some of the links from earlier posts.
As for the other part, the benefits may outweigh the risks but don't be surprised if performance actually suffers. Going to 64-bit may offer benefits from an operating system point of view and these benefits may be passed through to the product, but the benefits are subtle and not easily identifiable or quantifiable on a day-to-day basis.
"Beliefs" get in the way of learning.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply