How can I determine if I should move a process/data using an OLTP system to
an OLAP system? The OLTP system generates some reports (by account number)
using data from multiple tables, temporary tables (subset of main tables),
and user defined functions.

Two of the tables I'm using have 16 & 520 million records (respectively). I
have created partitioned views in order to reduce the size of the tables but
I'm still having problems with speed. The data in the partitioned view is
sliced using the year part of the processdate column/attribute.

If OLAP is the answer, how many concurrent users will the OLAP system will
support? The current system only allows a few account numbers to run the
reports but I would like to have the capability to run the reports for all
accounts 320k+

Im' pretty sure that olap will performn better with those record amounts.

However - you perhaps need to present data in a different manner - you need
to use hierachical dimensions as much as possible - so users go from an
aggregated
level to detail - not only does this give you a better information but that
is what olap "like" regarding performance

And there is a monster article from ms with performance tips...


"saleyoun" <saleyoun (AT) discussions (DOT) microsoft.com> wrote