SQL Server Performance

Raid for Datawarehouse

Discussion in 'Performance Tuning for Hardware Configurations' started by lital, Jan 14, 2003.

  1. lital New Member

    I need some info about implement raid
    for datawarehouse Can you help me
  2. royv New Member

    Well the one thing I can tell you is for a datawarehouse, you want a fast read solution. The best RAID out there is RAID10 (RAID 1+0). If you can't do that, then do RAID 5, which offers the next best read solution.


    "How do you expect to beat me when I am forever?"
  3. bradmcgehee New Member

    If your SQL Server will be a data warehouse only, and not be subject to data modifications, either RAID 5 or RAID 10 will be equally OK. RAID 5 is great for reading data, but poor for data modifications. But if you are only reading data, then RAID 5 will work just about as good (and it much less expensive).

    The key to fast reads, using any RAID, is to have a fast controller and lots of disks per channel. Find out from your vendor what they recommend for the maximum number of disks for the controllers they sell.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  4. lital New Member

    what about my Tlog and the Tempdb
  5. royv New Member

    Do you mean to say that you will be creating temp tables in this data warehouse? If you have SQL Server 2000, look into table variables.


    "How do you expect to beat me when I am forever?"
  6. bradmcgehee New Member

    In data warehouses, the transaction log is not used much, so its placement is not critical. I would probably place it on the same RAID array as your data.

    Your tempdb database may or not be very busy. If you expect it to be busy, consider putting it on its own RAID 1 array. See my website for more information on how to optimize the tempdb database.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  7. sqljunkie New Member

    I am curious how TempDB would be used in a DW?

    If you have an existing environment I would suggest that you collect some performance monitor data on the disk drives to determine how much writing will be done. If there is a lot I would go with RAID-10 if there isn't I would go with RAID-5.
  8. bradmcgehee New Member

    Sorting and GROUP BY operations in a data warehouse would make use of the tempdb.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page