Post reply

Server for Data Warehouse

  • June 15, 2005 at 6:59 pm

    #164022

    My cleint is gettign a new server just for use as a SQL Server data warehouse.

    most of the databases will be read only and refresehd at night.

    Exepct about 20 active users doing queries, and running SQL Reporting services.

    Any thoughts on what to reccomend for hardware:

    Disk RAID,

    Memory

    cpu

    Etc.

    Thanks

     

     

  • June 16, 2005 at 8:17 am

    #566114

    How big a DB? Is this just reporting services? Are these complicated queries? Hard to recommend hardware. Can you estimate based on existing OLTP hardware?

    At a min, I'd go 2CPU, 4GB RAM, RAID 1. If you want more RAM, you need to go to enterprise edition. Or SQL Server 2005

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply