|
|
Posted by Erland Sommarskog on 10/08/07 21:58
Artie (artie2269@yahoo.com) writes:
> I was wondering if I could get some experienced opinions on SQL hardware
> to run an ERP app on SQL 2000. The app does not yet support SQL 2005.
> The ERP app has 25 users and likely won't exceed 30 users for several
> years. All traffic is on the LAN. The ERP clients basically submit SQL
> requests for reads and writes. The app makes heavy use of temp tables,
> temp views but not many stored procedures. The current size of the db
> is 6GB and will likely double in 4 years.
>
> Planned server:
> Windows Server 2003
> 4 GB RAM
> SQL 2000 Standard (ERP app does not yet support SQL 2005)
> RAID1 for OS
> RAID 10 for SQL data
> RAID1 for SQL logs
> RAID1 for temp db
> Dual, teamed NICs
>
> I would try to get 15K SCSI drives. Any thoughts on SATA instead of SCSI?
Hardware recommendations is not my best game, and it's always a gamble,
because there are so many "It depends". But from what you say, this
appears to be a very able server for your database.
> Could I expect much of an impovement by using SQL 2000 Enterprise since it
> can use more RAM? I would rather wait for SQL 2005 to be supported.
Given the price tag of Enterprise, I find it difficult to recommend
Enterprise when your database is that modest.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|