August 6, 2003 at 12:14 pm
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
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