SQL Server - How to setup our own web server for company web applications and Sql Server 2016

Asked By bhanupratap singh on 08-Feb-18 06:50 AM
Mr. Robbe Morris,

How to setup our own web server for company web applications and Sql Server 2016. Actually Currently our applications have been hosted on nexzen technology (web server provider). But there is speed issue. Our database is very large. spped is not as much as we expected. Now Should setup our own webserver at our end ?. Will it be best approch. Can we be able to increase speed after using 100 gb RAM , and will it cost too much for the company. ? We pay for server Rs 200000 per month.

Thanks.
Robbe Morris replied to bhanupratap singh on 09-Feb-18 06:10 PM
CPU, disk speed, and RAM all come into play with improving your performance.  Have you tried optimizing your queries and indexes used by those queries?  That is usually the answer versus going after better hardware.
bhanupratap singh replied to Robbe Morris on 10-Feb-18 01:44 AM
Yes ! we have optimized our query at development level with little bit big data. it run smoothly. But online it does not.
Therefore we decide, why not to setup our own web server. Will it be best approach ?