SQL Server locally slow but remotely fast
Have a query about the responses given by SQL server? Searching for the reasons as to why it is locally slow but remotely fast? Find suggestions from experts on this page.
I have a strange (and interesting) problem, I just came with a company to support it with the ERP. Every time the ERP client runs, it connects to a SQL server and creates a lot of views.
Well, if they run the ERP client on any computer on the network, the queries are pretty quick, but if you run the client on the sql server locally, then it takes up to 20 times the time it takes to run them from the remote computer.
I traced some queries from the ERP, executed them locally and they were executed very fast.
In summary, only when the client is used locally, queries are very slow.