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 d/EPM Administration to monitor activity.

The OLAP Service offers additional performance monitor counters to gather more information. For example, the number of active users.