Boost Performance for Large Data Warehouse

When we deal with large data warehouse, it needs specific trick for best performance. I did presentation about this on last Oct 17 for Mini TechReady in Microsoft Singapore. Basically here are some guidances:

  • Take advantage from table partitioning for large fact table.
  • Put clustered index on fact table key, specially for datetime column and do partitioning based on this column.
  • Put non clustered index on non datetime column of fact table, when the query usually using exact criteria.
  • Do the query based on interval criteria, put BETWEEN on WHERE clause when dealing with datetime key, ofcourse after put clustered index on it.

There are another tips related to Analysis Services, hardware, and deal with Integration Services. Download my presentation here: SQL2005LargeDW
Due some users that encountered problem when download entracting the file, I have uploaded again. I have double tested and it works fine.

  3 comments for “Boost Performance for Large Data Warehouse

  1. andy
    October 20, 2006 at 11:27 PM

    Thanks!
    It’s very useful for me

  2. MCA
    October 31, 2006 at 4:32 AM

    Mohon maaf atas file yang corrupt ketika didownload. Sudah saya upload ulang, silahkan download lagi :)

  3. April 28, 2007 at 1:18 AM

    Hi, my name is Jonney, I am from Zaire.
    Just like your resource :).

Leave a Reply