improve performance web intellignce
Good morning, i have many users Web intelligence, how do i reduce the processing load my Server's webi? which servers have to duplicate?
Tim Forster replied
Sizing can be quite complex. This is usually going far beyond forum support. However there are a few things simple things you can try.
Assuming you use Webintelligence reports.
One CPU can handle usually 25-40 simultanious connections. In addition you can have one service per CPU. That means on a 2 processor maschine you should add a 2nd webintelligence report server in order to increase the number of simultaneius connections.
In addition you could consider splitting your users in 2 groups.
One group (Power users) which have the rights to run/refresh reports on demand and a second group which cannot run reports on demand but access scheduled instances instead. The reports for the 2nd group could be scheduled e.g. every night.
That would lower the processing load on your webi report servers.