vteam #472 is currently working on the product development of multiple credit repairing agencies by using Asp.Net MVC, MS SQL Server, Microsoft Azure Cloud. These agencies deal in credit repair for their customers. Their website encountered speed issues when it was deployed on server.
When their website was deployed on Azure cloud server with S0 (Standard performance level with 10 database throughput units) database package, it was considerably slower than another windows server.
To resolve this issue, vteam #472 installed ‘New Relic’ scripts in the website to monitor its performance. We found that response from database server is slow. We explored Azure documentation and found the solution to upgrade database package. Initially, we upgraded it from S0 to S1 (Standard performance level with 10 database throughput units) package. There was no significant change. Moving on, we upgraded from S1 to S2 (Standard performance level with 50 database throughput units) package. But still performance was not up to the mark.
Lastly, we upgraded from S2 to P1 (Premium performance level with 125 database throughput units) package. This shift of database server from S2 to P1 made a huge difference. Website was again normal in function as it was behaving on other windows servers.