Data Warehousing Server Spec

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

14 Sep 2005 03: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.
New Member
New Member

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

Kalman Toth, SQL & BI Guru

Acceptable Use Policy