set a sql server for OLAP?!

• crab7

  Mr or Mrs. 500

  Points: 548

  More actions

  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.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  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