Michael's profileMichael's BI SpacePhotosBlogListsMore Tools Help

Blog


    October 21

    SAP/BOE XI3.1 - Scheduling Scaling

    It's not always a case of just throwing more CPU and hardware when intending to scale up for increased processing activities - you need to understand the components that wil be impacted prior to scaling up either horizontally or vertically.

    Scheduling specific:

    Primary throttle point:      

    • Web Intelligence Job Server – scheduling request manager1 CPU can supposedly support 5 jobs – PROD currently has 2 job servers.

    Secondary throttle point:  

    • Web Intelligence Report Server – creates the report instances – will expand to use as many CPU’s as it requires and are available – user address memory cap of 2 GB per report server – Prod currently has 2 report servers.
      Note: Physical Address Extension (PAE) switch changes the addressing mod to enable the OS to access more than 4 GB RAM i.e. the Report Server 2 GB cap limit still applies, but you can effectively run multiple heavy processes.

    In summary:

    2 more CPU’s could double the current scheduling capacity but I would suggest adding more RAM and looking into PAE.
    We need:

    • To understand and adjust some parameters for XI 3’s built-in memory management.
      I.e. it is possible to recapture memory based on the “Enable Memory Analysis” options – I think the defaults are still in place.
    • Additional info on the unmanaged disk PDF generation overheads.
    • Average anticipated report run times / and sizes in case we have to adjust the -RequestTimeout parameter and the cache settings on the Report server.
      I.e.it’s not enough to just know anticipated disk space requirements as one also needs to scale parameters for anticipated load increases.
    • Review Tomcat heap settings and/or Tomcat 6 upgrade.
    • Review the CMS database for optimal use.   
    Generic:

    Web Application Server (Tomcat):

    • 400 sessions
    • 100 simultaneous requests per processor – non report requests i.e. folder clicks etc
    • 50 simultaneous report viewing requests

    CMS Database:

    • 600 concurrent active users
    Additional:
    • If Prod is a quad / 8 GB – and you're running on a 2 CPU license, it has yet to be determined if & how the CPU license cap throttles back on a server that is scoped beyond the cap.
    • Always collate detailed statistics on the existing installation prior to expanding – suggest this as priority 1.
      E.g. Use Perfmon or a similar monitoring tool over some consecutive batch and heavy user windows for OS / memory / processor / application stats.
    • A review of ALL XI component configuration parameters - apart from the built in memory management mentioned previously, there are also Web Intelligence Report Server cache clean / dirty memory settings still use the defaults.
    • The vendor has no recommendations for the Connection Server – possible throttle point – need to determine some thresholds on this component asap.
    • Tomcat 6.0.2 supposedly has improved Memory usage optimizations / Advanced IO capabilities - the default install is 5.5.
      i.e. always look if it is possible to gain from any new releases e.g. XI 3.1 SP2 running on Tomcat 6 - benchmark this first!
    • Crystal / Olap Voyager
      A total rethink will be required if intending to adopt / use these components along with scaling up for increased batch activity!
    • Etc.


    Comments

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.

    To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in


    Don't have a Windows Live ID? Sign up

    Trackbacks

    The trackback URL for this entry is:
    http://bi-deja-vu.spaces.live.com/blog/cns!E71C316C6625734E!307.trak
    Weblogs that reference this entry
    • None