March 22, 2005 02:22 PM

Betting on 64-Bit

Odds are that investing in 64-bit SQL Server will pay off
Rating: (0)
SQL Server Magazine
InstantDoc ID #45454
Although SQL Server 2000 Enterprise Edition (64-bit) has been available for 2 years, many organizations are reluctant to invest in it. In discussions I've had with clients, many DBAs and developers have dismissed 64-bit because they think it's suited only for very large database (VLDB) applications or massive Analysis Services OLAP deployments and would be too costly for their organizations. However, three compelling real-world scenarios might make you reconsider putting your money on 64-bit now. Let's take a look at the benefits 64-bit SQL Server can provide in database consolidation, consolidated business intelligence (BI), and SQL Server multi-instance clustering.

As ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Could be more indepth - config examples would be nice.

hughesg4a 11/4/2006 2:56:15 AM


Quote: "You can override this limitation with the addition of /PAE and /3GB switches to the boot.ini file, which changes the server to physical address extension (PAE) mode and lets your non-kernel applications use up to 3GB of memory. Keep in mind that all of a server's applications—including those we forget about, such as antivirus or monitoring software—must share those 3GB."
Isn't it so, that by using the /3Gb switch, you increase the user memory part for each process (which is not shared between applications) to 3Gb, and decrease the kernel memory part (which is shared between all applications) to 1 Gb?
Gé Brander

ge@familie-brander.nl 10/27/2005 4:26:37 AM


Be sure to remember, that if you plan on deploying x64 systems, Windows server 2003 x64 doesn't for the time being support .NET 1.1 - that means e.g. no Reporting Services.

Jacob5/13/2005 1:18:17 AM


You bring up some excellent points. One thing I would like to point out, however, is that if an organization already has multiple 32-bit servers in place in either an active-passive or active-active setup, there is a way to go to N+1 without the "gotchas" and without upgrading everything to 64-bit. Simply make the "+1" server, i.e. the failover server, a 64-bit server which would be able to handle several 32-bit active clusters failing at the same time. True, they would be relagating their most powerful hardware to a role where it is usually not (hopefully never) used, but that is cheaper than going to an all 64-bit setup or multiple active-passive clusters and avoids the gotchas of the active-active scenario.

Andrew Steitz
acsteitz_(a)_yahoo.com

STEVEN5/5/2005 1:06:34 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS