I am running sql server locally as it is a developer environment. When ever i do an intensive task sql chews up all my ram and slows my machine to an almost stop. I don't care if it uses most of my ram but the fact that it slows everything
else down is extremely unproductive. When its doing the task my CPU Usage sits around 50% but the ram gets mostly used. I tried limiting the ram but this does not stop it from slowing the machine only stops it from using so much memory. I susspect its either
the HDD or Ram Bas speed that is the problem.
Anyway is there anything that can be done so SQL is a little less greedy?
View Complete Post