First, if you haven’t tried PAL yet, I highly recommend downloading it from CodePlex and giving it a try. You start by capturing a set of performance counters (which PAL recommends), then feed it to PAL to analyze against a set of recommendations and then output problem areas flagged as yellow or red depending on the severity. Great tool, great price – free!
During the recent PASS Summit I met Pedro Lopes from Microsoft and he is working on enhancing the recommended values for all the SSAS counters. I’m attaching the spreadsheet he provided, he’s looking for any input you can offer to help him update the recommendations that go into PAL. Send back what you can, and please let any colleagues that work with SSAS know in case they can help too.
