Moving data from OLAP db to OLTP db

• spsql

  SSC Enthusiast

  Points: 187

  More actions

  September 30, 2010 at 10:44 pm

  #228924

  Hi All,

  I need some help on understanding the performance impact when data is moved from OLTP database to OLAP database. In particular, what i want to know is when a process moves data from OLTP to OLAP database, how would it impact the performance of applications writing to OLTP DB and impact on applications reading data from OLAP database.

  Please share your experiences.

  Thanks

  SP

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  October 1, 2010 at 1:10 pm

  #1230462

  spsql (9/30/2010)

  ---

  I need some help on understanding the performance impact when data is moved from OLTP database to OLAP database. In particular, what i want to know is when a process moves data from OLTP to OLAP database, how would it impact the performance of applications writing to OLTP DB and impact on applications reading data from OLAP database.

  ETL processes moving data from OLTP to OLAP have an impact on I/O as well as on processing power (CPU/Memory) - that's why ETL processes are usually scheduled to run at a time where there is little activity in both databases.

  How much of an impact? It depends of local conditions like, volume of data to be moved, plaform, how good or bad are the OLTP and OLAP database designs, quality of ETL proceses, bandwith, etc, etc, etc.

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.