October 31, 2011 at 12:21 pm
Details:
Physical memory:6GB
64bit OS
windows 2008
sqlserver 2008
2 processors/2.67 Ghz
I have a windows 2008 and sql server 2008 on it.
Currently sqlserver.exe is using up all the memory.It fluctuates between 90 to 95% of the memory present.(Physical box not virtual.)
I would like to set the min and max memory utilised by sql server .How to calculate the min and max values.Can I get any t-sql to calculate these min /max values
Task manager shows:CPU used:1% to 5%
Physical memory :5.77 GB.Once I restart the sqlserver.exe service,it comes down to 2.0Gb physical memory used.Obviously sql server is not releasing the memory back to the OS once it grabs the memory.How do I prevent this from happenning.Are there any repurcussions if I leave it the way it is presently.
Thanks
November 1, 2011 at 9:01 am
What does this say?
SELECT *
FROM sys.configurations
WHERE name = 'max server memory (MB)' ;
You can set the max amount the buffer pool can use by setting this option...however if SQL Server is grabbing more memory because of SQL CLR operations there is nothing you can do about that. It's just like any other .NET app...if it needs memory it will request it from the OS.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 2, 2011 at 11:51 am
Do the appdomain errors mean issues with the server/database?
Does this error mean trouble?
Error:appdomain is marked for unload due to memory pressure.
November 2, 2011 at 11:54 am
sqlserver12345 (11/2/2011)
Do the appdomain errors mean issues with the server/database?Does this error mean trouble?
Error:appdomain is marked for unload due to memory pressure.
It can mean trouble.
What are the results of the query I posted previously?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 10, 2011 at 12:30 pm
Query result:
1544
max server memory (MB)
2147483647
16
2147483647
2147483647
Maximum size of server memory (MB)
1
1
November 10, 2011 at 12:32 pm
Query result:
1544
max server memory (MB)
2147483647
16
2147483647
2147483647
Maximum size of server memory (MB)
1
1
November 10, 2011 at 10:17 pm
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply