32bit Enterprise vs 64bit Standard
in [Server Configuration]
|
From: Ken Ross on 30 Mar 2010 18:32 If you were setting up a new SQL 2008 server that you knew would need access to at least 8GB of RAM, and you didn't need any of features exclusive to Enterprise edition, would you go with SQL 2008 64bit Standard Edition or SQL 2008 32bit Enterprise Edition in order to gain access to the full 8GB? An odd question, but one my customers seem to ask a lot. Thanks.
From: jgurgul on 31 Mar 2010 04:04 Hi If you do not need the features of enterprise, then why would you not install 64bit standard (or 32bit with appropriate flags)? http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx http://msdn.microsoft.com/en-us/library/ms143506.aspx Jon "Ken Ross" wrote: > If you were setting up a new SQL 2008 server that you knew would need > access to at least 8GB of RAM, and you didn't need any of features > exclusive to Enterprise edition, would you go with SQL 2008 64bit Standard > Edition or SQL 2008 32bit Enterprise Edition in order to gain access to the > full 8GB? > > An odd question, but one my customers seem to ask a lot. > > Thanks. > . >
From: Andrew J. Kelly on 31 Mar 2010 13:34 I wouldn't use 32 bit period on any new server these days. x64 bit standard will access all the memory the OS sees so it's a no brainer. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Ken Ross" <kross(a)horizonsoftware.com> wrote in message news:Xns9D4BBC9131E54krosshorizonbosscom(a)207.46.248.16... > If you were setting up a new SQL 2008 server that you knew would need > access to at least 8GB of RAM, and you didn't need any of features > exclusive to Enterprise edition, would you go with SQL 2008 64bit Standard > Edition or SQL 2008 32bit Enterprise Edition in order to gain access to > the > full 8GB? > > An odd question, but one my customers seem to ask a lot. > > Thanks.
From: Ken Ross on 31 Mar 2010 18:02 "Andrew J. Kelly" <sqlmvpnooospam(a)shadhawk.com> wrote in news:OCkhkhP0KHA.264(a)TK2MSFTNGP05.phx.gbl: > I wouldn't use 32 bit period on any new server these days. x64 bit > standard will access all the memory the OS sees so it's a no brainer. > This has always been my take on things too [and 2K8 R2 makes the choice even easier] but I've still run into the odd customer [no pun intended] that I think feels some level of comfort with staying on 32bit and so takes the Enterprise route to get the extra RAM.
From: Andrew J. Kelly on 31 Mar 2010 19:00
So they would rather spend 10's of thousands of dollars more for the EE license just to stay with 32 bit. Wow. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Ken Ross" <kross(a)horizonsoftware.com> wrote in message news:Xns9D4CB77DCB8DDkrosshorizonbosscom(a)207.46.248.16... > "Andrew J. Kelly" <sqlmvpnooospam(a)shadhawk.com> wrote in > news:OCkhkhP0KHA.264(a)TK2MSFTNGP05.phx.gbl: > >> I wouldn't use 32 bit period on any new server these days. x64 bit >> standard will access all the memory the OS sees so it's a no brainer. >> > > This has always been my take on things too [and 2K8 R2 makes the choice > even easier] but I've still run into the odd customer [no pun intended] > that I think feels some level of comfort with staying on 32bit and so > takes > the Enterprise route to get the extra RAM. |