On a client with 300 Service users and 6 Million Mail addresses we have some performance & stability challenges.
I would like to ask the community:
(1) The App Server has 16 Core and 32GB, which seems alright. But the server runs out of memory and around 100 Ticket.exe processes are open. Anybody can recommend something? At the moment we need to restart IIS 1-4 times a DAY.
Would changing the session state from inproc to SQL improve that behaviour?
(2) In general it seems that Application server processes take quite some time and SQL Server needs to wait to deliver results back.
Any recommendations to improve on this end?