Skip to end of metadata
Go to start of metadata

Product versions:
Xcelsius 2008
BusinessObjects Enterprise XI 3.1 SP3

Table of contents

This article is part of a series

Introduction

This article aims at providing guidelines to size the new Xcelsius servers. They are based on tests performed at SAP that focused exclusively on Xcelsius usage. A lot of other factors / user activities will obviously influence a sizing exercise on a real production system.

How many servers do I need ? How many users per server ?

Rules of thumb :

  • one Xcelsius Cache Server can handle 50 concurrent requests, which translates into between 250 and 500 logged on users (active usage rate between 10 and 20%).
  • one Xcelsius Processing Server can handle 50 concurrent requests. This can potentially translate into 1,000+ users depending on how much data can be shared across users.
  • the WebIntelligence Processing Server was set to 50 concurrent connections, this may be tuned further depending on the other WebIntelligence related workload (WebIntelligence documents, LiveOffice, Mobile). This can potentially translate into 1,000+ users depending on how often the SQL has to be regenerated.

As it was done in the optimal performance scenario, it is possible to have multiple Xcelsius Cache Server instances for a single Xcelsius Processing Page Server. In fact, this would be ideal from a performance standpoint, as most of the requests would be handled by the cache(s) and not require any interaction with the database.

What are the main factors that drive the sizing ?

Here are factors that need a careful assessment when doing a sizing exercise for the Xcelsius servers.

user-level universe security restrictions

this increases the need for more WebIntelligence Processing Server(s) : increase the maximum number of connections per WebI server and/or increase the number of WebI servers

frequent changes to universes

this increases the need for more WebIntelligence Processing Server(s) : ensure the QaaWS objects are re-published whenever the underlying universe is changed, or increase the maximum number of connections per WebI server and/or increase the number of WebI servers

data latency and share across users

frequent data changes in the database and / or each user with his own data set(s) increase the need for more Xcelsius Processing Server(s) : increase the number of XC Proc server

  • No labels