August 2, 2010 at 3:01 am
Dear All
A client of mine faces performance problem. When looking into I realise that sqlserver network service consumes 7GB memory. There are 3 sql instances on the computer together with exchange server(despite all our recommandations). How can I solve this problem?
-------
Sorry it was not clear enough and was indeed time consuming for you,
It was that, I could not find which instance consumes that much, I dig in to all instances and check with process id, when I attached this message, I had not find it yet.
Now I found it belongs to the sharepoint, for which I have no rights to see.
Sorry for the inconvenience
August 2, 2010 at 4:48 am
I am not sure what do you mean by SQL Server Network Service. SQL Server does not install any such service during installation.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
April 6, 2011 at 1:23 am
can u please look on this
Physical RAM Target Avail RAM in Task Manager
< 4GB 512MB – 1GB
4-32GB 1GB – 2GB
32-128GB 2GB – 4GB
> 128GB > 4GB
You can use T-SQL to set your MaxServerMemory setting. The sample below sets it to 3500, which is the equivalent of 3.5GB. This setting is dynamic in SQL Server 2005/2008, which means that you can change it and it goes into effect immediately, without restarting SQL Server.
-- Turn on advanced options
EXEC sp_configure'Show Advanced Options',1;
GO
RECONFIGURE;
GO
-- Set max server memory = 3500MB for the server
EXEC sp_configure'max server memory (MB)',3500;
GO
RECONFIGURE;
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply