I have a SharePoint 2010 farm with three servers :-
Server 1 - WFE
Server 2 - CA + WFE
Server 3 - DB Cluster + WFE
I have Excel Calculation Services Started on all the servers.These are my questions
a) Do I need to configure any alternate access mappings to ensure that excel services is used evenly across all three servers?
b) What happens when excel services consumes maximum amount of permitted memory in a server ? Does the application pool automatically recycles in that case or the system crashes ?
c) The farm's user base is around 3500 average daily unique visitors.50% of them open large excel files in their browsers and does a lot of calculation. From performance standpoint what should be my correct approach towards capacity planning for the same. Do I need to add more application servers or do I need to increase the RAM in the web front end servers ?
d) Is there a way to determine the number of excel sessions created across the entire SharePoint sites in a farm at any given time ?
e) What really happens when I manually recycle the application pool in IIS that runs excel calculation services ? I have done that sometimes to prevent excessive consumption of memory however Im not really sure whether is it a good practice. Please suggest here.