[Webinar] Streamline your web hosting managementRegister Today

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,119 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
7 Comments
 
LVL 97

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 97

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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

A safe way to clean winsxs folder from your windows server 2008 R2 editions
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

607 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