>Could you exlain more about this?

Generally speaking, a data mart is a denormalized set of tables that are usually synthesized in a way to optimize queries.

Just like OLTP database tables are usually normalized to post data as efficiently as possibly, data mart (and data warehouse) tables are usually less normalized, for frequent queries.


But it means a period of posting new transaction data to the data mart. Some people do it nightly, others weekly....and some will do it every 30 minutes.

Of course, that means a lag, between when data is posted to txaction tables, and when they appear in the data mart. For some, that lag is OK. Others find it unacceptable.

SQL 2012 and 2014 enterprise have introduced some new data warehousing type features that help with the lag.

This is just an extremely brief overview. But it does sound like you might have some overloading in the process, and a data mart can sometimes help. More details would need to be covered to see if this would really help, but I do think it's something to at least consider.