Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
postrio1
Starting Member
1 Post |
 Posted - 2010-04-10 : 20:53:51
|
| Hello, newbie asking for advice before purchasing a server. It needs to run SQL 2008 for 4-6 users simultaneously. I want a Raid 10 configuration with 15K RPM hard drives. I am choosing between a refurbished server with 8 146 GB 15kRPM hard drives and a single 2.66GHz processor, vs a new server with 4 of those hard drives but dual processors.My question is, should I put my money towards extra hard drives, or is 4 enough and I should put the remaining money towards extra processing power. Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-04-10 : 22:45:04
|
| If you plan on only having 4-6 users simultaneously, then you don't need to purchase a very big server. CPU and memory are typically more important than the disks in regards to a database server for SQL Server. 15k RPM disks would be overkill for just 4-6 users. Put your money towards memory instead.How big is the database expected to be? What kind of activity will the users be doing?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-11 : 02:16:21
|
| I would want multiple core CPUs at least ... I think a single CPU (and single core) would be a bottleneck.Database size is the next important factor, as Tara has asked. If its many GB big then more RAM is important. If its only a few hundred MB then "ordinary amounts of RAM" should be enough. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-04-11 : 06:17:46
|
| Focus on configuring the SQL Server - such as splitting out Data,Log,tempdb files. Are you running a DataWarehouse with reporting or more OLTP type activity ?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
new server advice