We have a pay-as-you-go Azure server for an IoT application which is bordering on mission-critical. The server runs IIS and SQL Server. Our database has about 100 tables, some of which have over 1.5 billion rows and we have thousands of remote devices posting information to the server every few minutes.
The speed of the responses is fine, but the reliability is not great. The server often needs restarting, or the website has to be deleted and rebuilt. There are quite a lot of time-outs for clients.
So far we have managed this in-house, but I think we now need some specialist analysis and advise. Should I take out a support contract with Microsoft or look for a third-party company to get involved? If so, what sort of company would provide this sort of advise?