• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1122
  • Last Modified:

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

Is Intel I5 processor suitable for SQL server 2005 32 bit or 64 bit?
0
GSGDBA
Asked:
GSGDBA
4 Solutions
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
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
 
GSGDBAAuthor Commented:
What would you suggest for testing server?
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
KCTSCommented:
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
 
shanyuenCommented:
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
 
chqshaitanCommented:
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
 
GSGDBAAuthor Commented:
Thanks for your valuable comments
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now