No sense in repeating the article, full steps available in the Technet posting "Install PerformancePoint Monitoring Server with SQL Server 2008".

The instruction detail is great, although I do not see a lot of our customers going for this set up as it is a bit of a hack.

The other thing to note is that this instruction set concerns the Monitoring portion of PerformancePoint only – for most people, this should not be a concern, as MS did not see a big uptake on the Planning piece anyway (and none of my direct clients have show interest either).

For the most part, I would really only recommend doing this if:

  • You want to take advantage of some of the new features in SSAS 2008
  • Existing SQL 2008 farm
  • Memory management headaches in SSRS 2005 are making you want to move to 2008

The list is not comprehensive by any means, but it is just a few of the reasons I can directly see. Feel free to post or e-mail me with any challenges, questions or scenarios!