We are running a dual processor server E5-2630 V3 / 64 GB RAM with Windows Server 2012 R2, this server has IIS and SQL Server 2014 installed, only one web service is running to serve a mobile application.
The server is serving almost 500,000 active users with around 500 requests per second, we are maxing out the resources of the server so we are thinking about splitting this dual processor server into 2 single processor servers, one for IIS and the other is just dedicated for SQL Server.
We already tuned our SQL server and did everything to improve performance, we are also using redis for caching to minimize hitting the database.
The first question is, is it a good idea to split the dual processor server into 2 single processor ones?
Do you recommend a specific configurations for our situation?
We are recently seeing events in the application log about SQL Server starvation for worker processes, due to all processes is being used, at peak times things are getting slow.
Any advice?
Thanks