OLAP database in production environment
The OLAP database in a
production environment consumes CPU power and memory in conjunction with the number of
users and individual work processes. These are some examples of the processes that
consume CPU power and memory:
- Reading data.
- Writing data.
- Automated mass data processes.
You can use the Databases dashboard in EPM Administration to monitor activity.
The OLAP Service offers additional performance monitor counters to gather more information. For example, the number of active users.