How to optimize server with Aps.Net + SQL?

Question

SQL Server

There are 2 servers:
1 - the server on which the applications are running.
2 - the server on which SQL Express is deployed with a database from applications
On server 1, the parameters for connecting to the database server are registered.
The problem is, it takes a very long time to load data from the browser. Restarting the database server helps.
Is it a crookedly configured server, network, or is it some kind of SQL Express limitation, such as cache size?

Answer 1

More shortly, all problem was in the DB. After optimizing the indexes and clearing the procedural cache - everything returned to normal