Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1117
  • 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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