Freigeben über

Performance Point Server Planning Dependency on SQL Server Enterprise Edition

  • Artikel

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.

Technorati Tags: Performance Point Server,SQL Server,Writeback,proactive cacheing

Comments

  • Anonymous
    December 10, 2007
    Nice post Andrew, thanks for clearing that up. Derek

  • Anonymous
    January 09, 2008
    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.

  • Anonymous
    January 16, 2008
    The comment has been removed

  • Anonymous
    June 07, 2008
    "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).

  • Anonymous
    July 16, 2008
    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!

  • Anonymous
    October 14, 2008
    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?

  • Anonymous
    October 15, 2008
    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.  

  • Anonymous
    November 23, 2012
    Nice Article ..