Solved

SQL Server 32 bit vs 64 bit

Posted on 2013-01-04
5
575 Views
Last Modified: 2013-02-04
I currently have SQL Server 2012 Express 32 bit running on 64 bit Windows Server 2012. Unfortunately, the work and downtime it would require me to change this is rather high at this point.

My question:
Is the difference in architecture big enough to warrant the work necessary to uninstall the 32 bit and install 64 bit?

I can't find any information on the true performance potential difference.
0
Comment
Question by:weblocked
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 38746010
Hi weblocked,

The biggest difference that you'll see is that the 64-bit architecture can more easily use much larger memories.  The are other differences, to be sure, but memory is the biggest one.

If your server isn't memory starved, I'd put off an upgrade until it's more convenient.


Good Luck,
Kent
0
 
LVL 11

Assisted Solution

by:MajorBigDeal
MajorBigDeal earned 166 total points
ID: 38746013
http://go4answers.webhost4life.com/Example/slow-performance-64-bit-sql-system-47545.aspx

I know this seems hard to believe but you could well experience worse performance with 64-bit SQL Server on your 64-bit Windows server.  And even assuming 64-bit was running well, you'd need a pretty big load before the performance difference would become apparent.

So in general and without more info, I'd say no, it isn't worth the extra work.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 38746022
Haven't gone through this yet myself, but memory has gotta be the big one.  Did find a blog on MSDN that went through some of the factors and as mentioned by the previous people in this question, it depends a lot on what your current situation is.

http://blogs.msdn.com/b/sqlprogrammability/archive/2007/04/30/will-64-bit-increase-the-performance-of-my-sql-server-application.aspx
0
 
LVL 2

Assisted Solution

by:MaxEL_UA
MaxEL_UA earned 167 total points
ID: 38746031
Hi,
Express Version have huge limitations that are more affects productivity than 32-bit limitations.
To be upgrade-ready - install 64-bit version, but if You don't planning to upgrade to Std/Ent/DWC/DC - dont't waste your time
0
 
LVL 78

Accepted Solution

by:
arnold earned 167 total points
ID: 38746221
http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx limits

The limitation for the express version mean it would not significantly matter since the limit is 1GB of ram for the sqlserver instance.

As others pointed out, going to an Standard version will make a more significant performance impact.  You can install a standard as a default instance and then transfer/copy the logins fom the express into this version, then you could switch a database/application at a time.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question