Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Is Intel I5 processor suitable for SQL server 2005 32 bit or 64 bit?

Posted on 2010-09-14
7
Medium Priority
?
1,113 Views
Last Modified: 2012-05-10
Is Intel I5 processor suitable for SQL server 2005 32 bit or 64 bit?
0
Comment
Question by:GSGDBA
[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
7 Comments
 
LVL 96

Assisted Solution

by:Lee W, MVP
Lee W, MVP earned 124 total points
ID: 33679708
It should work fine, if that's what you're asking, assuming you have very minimal databases.  Beyond that, it MAY work fine - it really depends on the requirements of your databases/database applications.
0
 
LVL 3

Author Comment

by:GSGDBA
ID: 33679762
What would you suggest for testing server?
0
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 33679778
Depends what you're testing.  If your testing a load the size of google.com, then I'd suggest a server farm with thousands of systems.

If you're testing a load of 3 workstations running a query every 5 minutes, then an i5 should be more than fine.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 70

Assisted Solution

by:KCTS
KCTS earned 124 total points
ID: 33679950
The I5 is a 64 bit processor, so assuming you install a 64bit version of Windows, you can run SQL64 bit and take full advantage of the better performace and memory management.

You can install a 32 Windows/SQL in the I5 but you will not be utilizing the hardare to its best advantage
0
 
LVL 5

Assisted Solution

by:shanyuen
shanyuen earned 124 total points
ID: 33680455
Both of them would be fine.
64 bit OS with 64 bit SQL is the right choice.
Because 32 bit OS/APP cannot use memory higher than 4 GB.
2 ^32 < 4 GB

So why still using 32 bit ?
0
 
LVL 5

Accepted Solution

by:
chqshaitan earned 128 total points
ID: 33680841
Yea, to follow up on everyone elses comments the processor is fine for any reasonable sized database. The critical constraint on a database is ram, the processor (within reason) is secondary.

If the database is small enough to fit into ram you are onto a winner.
0
 
LVL 3

Author Closing Comment

by:GSGDBA
ID: 33805127
Thanks for your valuable comments
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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 …

609 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