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 |
|
klegrand
Starting Member
29 Posts |
 Posted - 2004-11-23 : 10:40:54
|
| What's the best way to define a good pc/server according the amount of records (+/- 4000records a day).We have an excisting pc with SQL on it. We must made the descision to buy another pc or not upon the inserted records.thx,Kurt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-23 : 13:59:57
|
| Number of inserted records is not enough information to help you out. We'd need to know how big the database is, how many concurrent users, etc...Tara |
 |
|
|
klegrand
Starting Member
29 Posts |
Posted - 2004-11-23 : 14:29:02
|
| Tara,At this moment we have a small database on Window XP professional on a of the shelve pc. We are looking forward and then we would have 4000 inserts/day. There are +/- 10 users connected to it.Is it a good idea to change to a Raid5 ? |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-11-26 : 10:39:48
|
| 4000 inserts/day is a small number. But over the period data may grow (if you don't archive it..)raid5 is a big thing and quite expensive also. Try a normal server with proper backup stratergy.....10 users is not a big number. I will not suggest RAID at the moment...------------------------I think, therefore I am |
|
|
|
|
|
|
Server definition