Home > Uncategorized > MOSS/PPS/SSAS Testing and Tuning

MOSS/PPS/SSAS Testing and Tuning

I often refer to the Charlotte-Mecklenburg Schools’ dashboard in my presentations, workshops etc. as it’s a live, internet-facing, real-world implementation of PerformancePoint that anyone can visit. I’ve also recently discovered a blog post from David Darden that talks about the testing and tuning of an internet-facing PerformancePoint dashboard. I don’t know if the two are related, but taken together they do offer a great indication of both the design process and final outcome of a dashboarding project.

He makes some interesting points about the security methods chosen, hardware configurations, load testing and very specific tuning methods for this scenario. Most interestingly, some hard and fast performance stats:

“With our heaviest test case, I was able to run 1,500 concurrent users. The WFE processor was at ~70% utilization, averaging 300 requests per second with no contention or queuing. The database server was at ~20 utilization, no issues. Responses were < 1 second, with an average response time of ~.3 seconds”

Good read for anyone looking at PPS in large user volume scenarios, especially web facing…

Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: