Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Performance Point Server Planning Dependency on SQL Server Enterprise Edition

Performance Point Server Planning Dependency on SQL Server Enterprise Edition

  • Comments 8
  • Likes

Sorry about the catchy title, but I wanted to clarify why the planning component of Performance Point Server in turn depends on SQL Server Enterprise edition.

I pointed out in my recent TechNet presentations that Performance Point doesn't make use of the cube write-back feature of analysis services, which is one of the extra features in enterprise edition. Well I have done some digging around and it does and doesn't use cube write-back.

One of the main problems with cube write-back in SQL Server is that although the write -back itself is fast query performance degrades and more and more writes are done to the cube.  So Performance Point only uses write back to do what if analysis i.e. when changes are submitted to a model they are then written back to the database which then refreshes the cube.

To get this new plan data into the cube Performance Point uses another Enterprise only feature of analysis services, pro-active caching.  This is where the cube is automatically updated when the underlying data is changed.

So hopefully that clears up the confusion between what my good friend Ben Tamblyn and I have been saying about write-back.

Comments
  • Nice post Andrew, thanks for clearing that up.

    Derek

  • hi andrew,

    i want to know which version of sql server will be suitable for PPS to work. whether evaluation version or express edition or anything.

  • Gowdhaman

    drop me an e-mail and I'll reply off line (afryer@microsoft.com)

  • "PPS" works well with MS SQL Server 2005 with installed SP2.

    "PPS with SP1" works with MS SQL Server 2008 also (non-production use only).

  • Very good post Andrew.

    Regarding the pro active caching, I have noticed that it is not enabled on PPS-P created cubes (models). Only "MOLAP" is selected for partitions.

    Would you have more information on that?

    Thanks again for this very interesting post!

  • I also noticed that Proactive caching is not enabled on any of the MOLAP partitions that are created.  Where can we find more information on this?

  • Chris. Is the performance of performance point your concern? PPS is a product so I wouldn't recommend changing how it's configured underneath, just wait for the service pack and make recommendations on connect.  Do e-mail me (afryer@microsoft.com) if you have specific issues and I will pass them on.  

  • Nice Article ..

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment