Archive for 'Performance'

Apr200924

reagan

0

Data Warehouse Performance – Indexes

We are now dealing with index fragmentation on our data warehouse. After loading, updating, deleting, inserting, etc. hundreds of MB worth of data over the past month, the indexes that we initially created for the DW have become severely fragmented. This is one of the causes of the performance issues in the Data Warehouse.

Apr200924

reagan

0

Raw Data Warehouse Performance Issues

I am going to take a small break from the first series of this blog to discuss performance issues and considerations. This will only apply to data warehouses with raw data only (relational, not OLAP cubes).