使用Apache，Php的SQL Server 2014企业性能降低

Question

I have SQL server 2014 64bit Enterprise with 600,000 records running with Apache Server and Php5. My problem is that, loading and processing of data is very slow even access is thru localhost. Upon checking the process manager, i found out that SQL Service consumed at around 80-90% of the memory.By the way, I have 12Gb memory installed, and when i stopped SQL service memory suddenly drops to 5-15% usage. However. when i tried to execute query, select all, it just took around 40secs to 2mins to show all records which i think is fast enough compared to sql server 2012 below.

You guys experienced this problem? Maybe someone knows how to fix this. thanks.

Answer 1

Your question is very generic but, I try to help.

Go on Sql Server and click on server instance with mouse right button. Choose properties and go in the tab "Memory" and check the max dimension of Sql Server memory as the follow image:

The screen shot is in italian but I've added a red arrow to sign the parameter you must change.

This feature can resolve the issue memory.