I set up an online dedicated windows server in Godaddy hosting. The server has 32GB RAM, 2TB Storage, and 4 CPU Cores @ 3.1 GHz.
I installed SQL Server 2017 Enterprise Edition. Problem is this the queries which are taking seconds in the local machine, now taking minutes in the dedicated online server.
In most cases I see this error in my ASP WebForms app as well:
SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The performance issue sometimes exist and sometimes it works very good. If anyone guides me what do to fix this issue.