BEST Hardware for SQL SERVER 2005 or 2008

Posted on 2008-10-28
Last Modified: 2012-05-05

I am planning to buy a NEW system and install  SQL server 2005 to learn more on DBA activities. Please suggest me, where to start from and what, like:

Which laptop : DELL, LENOVA, HP...
What O/S etc.

Question by:Agesh
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
  • 3
  • 3
LVL 14

Expert Comment

ID: 22826895
So you want a Laptop specifically or would you consider a desktop also?

What is your price range?

Author Comment

ID: 22827262
A Laptop, I can afford around 1000 - 1500, Please recommend your thougths so that I can decide the price later.
LVL 14

Accepted Solution

dfxdeimos earned 250 total points
ID: 22827316
If you are just running a test environment you don't need a TON of power. I like Sager laptops personally... they are geared more towards gamers but they are very high quality and have a TON of power.

Lenovo also makes some nice laptops.¤t-category-id=1BE480ADA7EB421099C1676099E3EA34

Whatever you get, order something with at least 4GB of RAM. Then you will have no problems running virtual machines inside of your PC so you can experiment till your hearts content.
Industry Leaders: 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!


Assisted Solution

stevepo earned 250 total points
ID: 22832223
Look for at least 4 GB of RAM as the previous poster said and again I agree you don't need a ton of power in a test environment but for a comfortable experience you'll want at least a dual-core processor (Core 2 Duo preferrably) and also many laptops you find will come with a 5400 RPM hard disk drive.  Try to get a 7200 RPM Serial ATA drive (as opposed to IDE / ATA) if possible (it may be a little more expensive) but it will be worth it.

Expert Comment

ID: 22832348
Sorry for the double post but I forgot to add that the OS you'll need will depend on what version of SQL 2005 you are running.  I believe SQL 2005 Enterprise will only run on Windows Server 2000 SP4 and above.  SQL 2005 Standard will run on Windows 2000 Server SP4 and above as well as XP Professional SP2. SQL 2005 Developer edition will work on Windows 2000 Pro SP4 and above and I believe SQL 2005 Express will work on any of the aforementioned OSes
LVL 14

Expert Comment

ID: 22833632
You are correct about the OS requirements, but if you get a powerful enough machine you can easily run Virtual Machines with something like VirtualPC, install any OS you desire on the Virtual Machine, and then keep your development / test environment seperate.

Expert Comment

ID: 22834284
Very true, I am right behind you on using virtual machines.  The poster should do that as well, these days I always do any testing via Virtual PC as to keep my environments separate and give myself more freedom to explore the outcome of testing without worrying about messing up my primary machine / operating system.

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Able to access \\192.168.1.x  but not \\192.168.1.xx from windows 2012 server . 36 98
Uniden UDW20055 3 114
BgInfo help 5 102
Migrate SQL 2005 DB to SQL 2016 4 19
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Arrow Electronics was searching for a KVM  (Keyboard/Video/Mouse) switch that could display on one single monitor the current status of all units being tested on the rack.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

738 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