Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Memory settings


Memory settings

Author
Message
sqlnewbie17
sqlnewbie17
Old Hand
Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)

Group: General Forum Members
Points: 330 Visits: 1199
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
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8275 Visits: 14368
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
sqlnewbie17
sqlnewbie17
Old Hand
Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)

Group: General Forum Members
Points: 330 Visits: 1199
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.
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8275 Visits: 14368
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
sqlnewbie17
sqlnewbie17
Old Hand
Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)

Group: General Forum Members
Points: 330 Visits: 1199
Query result:
1544
max server memory (MB)
2147483647
16
2147483647
2147483647
Maximum size of server memory (MB)
1
1
sqlnewbie17
sqlnewbie17
Old Hand
Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)

Group: General Forum Members
Points: 330 Visits: 1199
Query result:
1544
max server memory (MB)
2147483647
16
2147483647
2147483647
Maximum size of server memory (MB)
1
1
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8275 Visits: 14368
Please read this article and follow its recommendations for setting max memory.

http://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search