Query on the Sql-server server, seconds out. However, it is very slow to view through the Web server.
Debugging through local code is also slow. The network problem is excluded, the statement problem is excluded, and the remaining memory in the Sql-server server is too small.
Learn from the blog Park predecessor SQL Server memory release experience, using the following statement, the effect is immediate:
DBCC Freeproccache DBCC Freesessioncache DBCC Freesystemcache ('all')DBCC dropcleanbuffers
Then, modify the maximum memory value through the statement as follows:
EXECsp_configure'Show advanced Options',1 --This is the opening of the advanced optionsGOEXECsp_configure'max server memory',10240 --set the maximum memory to 9G, our server memory is 16G, left 7G enoughEXEC('RECONFIGURE' )GOEXECsp_configure'Show advanced Options',0 --Remember to turn off the advanced options when you're done.GO
Another, by setting the way,
Sql-server consumes 98% of memory, resulting in slower transfer data