We have a SBS 2011 server with 32GB ram. Some developers have a product which seems to have an underlying issue with it timing out apparently between the desktops which connect to the SQL server on the above SBS 2011 server in some manner.
Their team has logged onto our server and performed some checks and see that that server is consuming 31592 MB of RAM. However when I look at Task manager the 2 highest processes are SQL and store.exe which are using:
Store.exe: 19,058,636 K
SQL: 1,642,748 K
From what I understand, is this not normal anyway, I assumed that these services use all the available storage for performance and release the memory to other applications as and when required.
Is this correct? At the moment all they have to go on is the above that may be the cause of the problem and the fact that some of the computers may be set to go into standby which apparently could be the cause of loss of network connectivity resulting in the loss of connectivity to the SQL database on the server.
Please let me know if you think the above memory usage scenario seems ok, there is only around 11 users on average. They worry about limiting memory on SQL because they feel it could cause disk caching and then possibly time-out.
Any insight would be appreciated.