February 19, 2009 at 2:52 pm
Hello,
I have been casting about all day looking for a good answer to this ... if our Windows server team installs 64 bit standard edition opposed to 64 bit Enterprise edition, will we see a difference in functionality in our SQL 2005 64 bit Enterprise edition? All the things I can find seem to talk about 64 bit period, without differentiating between Windows standard and Windows Enterprise. We are building an environment for a 600GB (and growing) database that needs high performance due to both heavy volume of operational load and some reporting usage. Will we be limited if they build a 64 bit standard edition Windows server?
Thanks!
Matt
February 19, 2009 at 3:11 pm
depends what you're going to need. Windows 2003 Std x64 bit is limited to 32GB RAM and 4 cpus.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 3:30 pm
I see, thank you. Our box is 2 quad cores with 8 gig of RAM. So is there any reason for us to go to Windows Enterprise edition? Is there functionality that potentially would be missed if we settled for Standard?
February 19, 2009 at 4:01 pm
The thing that Enterprise has over Standard that affects our environment is clustering, but it depends on your environment/requirement as to whether that's relevant. Here's a link to a table on Paul Thurrott's SuperSite that has a very clear comparison of the 32- and 64-bit versions:
http://www.winsupersite.com/showcase/winserver2003_editions.asp
The only real change when the x64 versions came along was an increase to the maximum RAM allowed for the Standard and Enterprise editions, as on the table on this page on Paul's site:
February 19, 2009 at 4:36 pm
Matt Klein (2/19/2009)
I see, thank you. Our box is 2 quad cores with 8 gig of RAM. So is there any reason for us to go to Windows Enterprise edition? Is there functionality that potentially would be missed if we settled for Standard?
if you dont plan to cluster or go above 4 cpus or 32 GB RAM then not really worth looking at enterprise TBH
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2009 at 7:34 am
Great links, thank you. That is the stuff I was mining the web for yesterday and missed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply