Data Warehousing Server Spec

Last Post 18 Sep 2005 04:25 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
king-kong
New Member
New Member

--
14 Sep 2005 04:13 PM
I am interested in the Server specification used for a medium-sized data warehousing environment.
Our data warehouse and marts are in the range of 5 GB to 40 GB and increasing.

The hardware for the production environment is a single processor PIII machine with 1 GB of RAM. The OS is W2K and the DBMS is SQL Server 2000. Currently, only reports are produced from the marts, and users don't have direct access to the marts. The company is moving towards using Analysis Services.

Any input would be much appreciated.
SQLUSA
New Member
New Member

--
18 Sep 2005 04:25 PM
You should have 4 cpus and 8GB of memory.

Kalman Toth, SQL & BI Guru
http://www.sqlusa.com



Acceptable Use Policy
---