I have set up my Magento hosting on Azure. I have 1 VM with 2 cores ( each of 2.14 GhZ), 3.6 GM RAM hosting apache and PHP code. Redis is set up as well.
Initially, this VM was hosting the SQL database as well, but after facing issues handling traffic, I moved my SQL database to a separate VM ( 1 core - 0.75 GB RAM).
I used this load testing online software - https://app.loadimpact.com
I simulated 50 VUs (gradually increasing from 1 to 50 within a minute).
I noticed that the load on the DB server never crossed 0.5
Meanwhile, the load on the apache + php server looked something like below -
For those unable to see clearly, the load average numbers are 48.27 23.75 12.81
This is just with 50 Virtual Users on the site.
Please advise how I should tackle this.