Skip to Content
author's profile photo Former Member
Former Member

BPC MS 7.5 performance issues

Hi experts,

Client is having performance related issues with BPC MS 7.5.

I will be talking with them today to get details but what I know so far is queries getting long time to run.

- Can someone please provide me some best practices or known issues related with performance?

- What questions I should be asking the client?

Following are the versions used:

BPC 7.5

Excel 2010

SQL 2008 R2

Windows 2008 64 bit

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2011 at 10:11 PM

    Reporting seems OK, input schedules are causing delays.

    To open a drop down to select a cost center takes about 15 seconds on average.

    To enter and populate the data takes about the same.

    Sending the data takes about 40 seconds on average.

    Apps not installed on users' computers, they are using virtual environment.

    Performance gets worse if number of users increases.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      You will have performance issues if you are using virtual environments. I have seen degradation in performance in virtual machine even on development system; with less amount of data. But when I access the same server without virtual machine, the performance is far better.

      I would suggest you to take this factor into consideration.

      Hope this helps.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.