/ Sign-up
Your question

What hardware configuration is suggested in running SQL server 2008?

  • Hardware
  • SQL Server
  • Servers
  • Components
Last response: in Components
March 24, 2010 3:46:12 PM

Running SQL Server 2008 Ent Edition on Server 2003 SP2, Dell Poweredge 2600 Server, 2.4 GHz Xeon Single Processor 1.0 GB Ram, SCSI HDD RAID 0 with static IP.
Currently SQL Server handles about 5000 I/O operations per seconds, have notice that CPU remains at 100% while processing queries, what kind of hardware changes are suggested in this type of scenario? or what is the best hardware configuration to run this SQL Server?

More about : hardware configuration suggested running sql server 2008

Best solution

March 25, 2010 4:59:19 AM

Before considering an upgrade, first check if you really need one. Shouldn't servers constantly run at high CPU loads? And are there any processes you should shut down for the sake of efficiency?

Whatever the case, you can upgrade your Xeon into those newer Gulftown numbers (not sure if they fit your mobo's current socket though), and add more RAM for starters.
March 30, 2010 5:24:43 PM

Best answer selected by angurpatel.