Link to home
Start Free TrialLog in
Avatar of Techdivision
Techdivision

asked on

sqlservr.exe memory consumption

Hi All,

One of our clients has been saying that it there server is running slower to the point of annoyance i.e. accessing network shares.

I had a look in processes and it seems to me like sqlservr.exe is consuming a fair bit along with w3wp.exe, there are multiple instances for both .exe's running.

Also for sqlservr.exe there seems to be both 64bit and 32bit versions running which seems very odd.

Here is a screen shot of the process's tab
User generated image
The server has 12Gb of memory and is currently using around 11.3 - 11.5 constantly.

One more thing, we will be rebooting it tonight so we shall see how it fair after that.

Thanks
TechDivision
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

SQL Server is a RAM hog.  It will grab and reserve as much memory as exists and leave just a bare modicum for the OS.  You can restrict the max memory that the SQL Server instance utilizes by changing the MAX MEMORY setting.  I would try restricting SQL Server to 8GB and reevaluate performance of both the SQL and the server itself.
ASKER CERTIFIED SOLUTION
Avatar of unknown_routine
unknown_routine
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You have three SQL server instance but all are not used as same. I will suggest as per Microsoft we should be set max memory 3 GB for two instance and 2 Gb for one instance (less used) and remaining 4 GB free for operating system.
Avatar of tmoore1962
tmoore1962

Probably a sbs2011 install sql management express and set the maximum memory for the instances, probably they are used by the document sharing on the sbs, you can also google setting the memory on the exchange mail store of sbs to help free up memory for filesharing etc.
Avatar of Techdivision

ASKER

@tmoore1962
Yes it is SBS2011, what would you suggest limiting the maximum memory for the instances too?
usually sql takes more memory please balance with proper page file