November 17, 2010 at 7:01 am
why will the sql server instanse use the a lot of memeory .
there are no jobs running at the moment.
the server has 24G of RAm and is using 19G and it is very slow.on the resource monitor and task manager
it only shows the SQL server instances has the highest number in memory usage.What will cause the this problem?
November 17, 2010 at 7:05 am
SQL Server will grab the amount of memory it requires but wont release it to OS unless OS asks for it. It will keep the memory with itself even when it doesn't require that amount of memory.
November 17, 2010 at 7:17 am
You can use 'max server memory (MB)' setting to limit the amount of the memory used by SQL Server. Use it with care.
You said the server is 'slow'. What do you mean by it?
...and your only reply is slàinte mhath
November 17, 2010 at 8:18 am
Thanx ,
we are running crm which is slow to open and navigate to other tabs.
crm application us nsitting on another server and the server is doing fine.
sql server is also running on its own server.
so now how do you set memory on sql server and how much should be allocated to sql instance if having 24G physical ram.
November 17, 2010 at 8:25 am
mangoale (11/17/2010)
Thanx ,we are running crm which is slow to open and navigate to other tabs.
crm application us nsitting on another server and the server is doing fine.
sql server is also running on its own server.
so now how do you set memory on sql server and how much should be allocated to sql instance if having 24G physical ram.
Are you sure your CRM is slow because of memory issue? what is the max memory configured for sql server? query sys.configurations view.
you can change the value using sp_configure.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply