Great! According to the spreadsheet, their web server needs to be able to handle around 208 requests per second. But if you run a load test on their farm, and you are given an Avg RPS, how many people can your farm handle based off the give utilization statistics? This was a bit harder to figure out, but eventually I got there. After plugging in the actual Avg RPS that the farm could handle while the hardware was still in it's "Green Zone" was 11. When you put that into the spreadsheet, the number of Total Users that should access their environment should be less than 1,320.
You can download the spreadsheet from here: http://sdrv.ms/Xp7Sq0
So the User Load in the Load Test does not correspond to the actual number of users the system will support?
ReplyDeletethe spreadsheet is a great idea, but your formulas dont handle the concurrent user% :)
ReplyDeletethis article points to concurrency and peak factor, which is perhaps more accurate :
http://blogs.msdn.com/b/sharepoint__cloud/archive/2012/09/21/how-to-calculate-throughput-and-peak-throughput-for-sharepoint.aspx
Anyway, currently battling with VS ultimate, which is a great tool, thanks for the pointers!