Post reply

set a sql server for OLAP?!

  • August 6, 2003 at 12:14 pm

    #159566

    Hi, here, I have rather general question, I think. I need to set up a SQL server 2000 which is used as a Repository server ( or data warehouse if you call it). And run all the batches to import large tables into it from other database systems.

    so I wonder is there some general rules to optimize the server when I set it up? or configure it?

    thanks.

  • August 6, 2003 at 9:15 pm

    #468921

    A couple of things that come to mind:

    1) for the redundant databases (data derived from operational systems) you might want to consider placing them on a simple RAID-0 set. This will give you faster loading speed than say RAID-5 and more disk space to play with. Your more important stuff, like master, msdb, and the database containing any import procedures should go on a more reliable RAID set.

    2) Consider putting the OLAP database into read-only mode during the day after import has taken place. This can overcome problems with procedures and ad hoc queries that have an inappropriate isolation level.

    Cheers,

    - Mark


    Cheers,
    - Mark

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

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