Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory settings Expand / Collapse
Author
Message
Posted Monday, October 31, 2011 12:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:09 PM
Points: 178, Visits: 579
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
Post #1198244
Posted Tuesday, November 1, 2011 9:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 7,098, Visits: 12,606
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
Post #1198737
Posted Wednesday, November 2, 2011 11:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:09 PM
Points: 178, Visits: 579
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.
Post #1199529
Posted Wednesday, November 2, 2011 11:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 7,098, Visits: 12,606
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
Post #1199534
Posted Thursday, November 10, 2011 12:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:09 PM
Points: 178, Visits: 579
Query result:
1544
max server memory (MB)
2147483647
16
2147483647
2147483647
Maximum size of server memory (MB)
1
1
Post #1203796
Posted Thursday, November 10, 2011 12:32 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:09 PM
Points: 178, Visits: 579
Query result:
1544
max server memory (MB)
2147483647
16
2147483647
2147483647
Maximum size of server memory (MB)
1
1
Post #1203798
Posted Thursday, November 10, 2011 10:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 7,098, Visits: 12,606
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
Post #1203907
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse