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 in SQL SERVER Expand / Collapse
Author
Message
Posted Monday, September 02, 2013 11:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 6:14 AM
Points: 37, Visits: 237
I have 4GB Ram on OS and What will happen to my SQL server if i configure Min memory settings more than OS RAM that is 5GB and Max memory settings 6GB on SQL Server Memory settings.

Post #1490752
Posted Tuesday, September 03, 2013 12:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
Since SQL will never be able to reach 5GB (and hence the min server memory setting will never take effect), nothing different to the default setting (where max server memory is a couple thousand terabytes)


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1490767
Posted Tuesday, September 03, 2013 12:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
We have only 2005 test server for us , so i tried on strange it is accepting the value.



Regards
Durai Nagarajan
Post #1490770
Posted Tuesday, September 03, 2013 1:00 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
Why wouldn't it accept the value?

If you check books online, max server memory must be a value between 16 and 2147483647, min server memory must be a value between 0 and 2147483647. The values you set are within that range, so they're valid.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1490775
Posted Tuesday, September 03, 2013 1:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 6:14 AM
Points: 37, Visits: 237
Is any issues with performance and if my SQL server is running state and configured SQL with min5GB and Max 6GB and the windows team suddenly decreed OS memory from 7GB to 4GB what will happen to SQL Server.
Post #1490777
Posted Tuesday, September 03, 2013 1:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
But why not they check OS Memory before accepting it?



Regards
Durai Nagarajan
Post #1490778
Posted Tuesday, September 03, 2013 1:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
santhosh411 (9/3/2013)
Is any issues with performance and if my SQL server is running state and configured SQL with min5GB and Max 6GB and the windows team suddenly decreed OS memory from 7GB to 4GB what will happen to SQL Server.


I already explained how it'll work. After SQL restarts (after the memory removal), it can't reach 5GB so the min server memory will never take effect. If the decrease in memory is permanent, you should go back and change the memory settings, but it'll be no different from a server with the default memory configuration of max server memory being 2000 or so TB.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1490781
Posted Tuesday, September 03, 2013 1:12 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
durai nagarajan (9/3/2013)
But why not they check OS Memory before accepting it?


Why should it?

How does SQL know that I'm not setting max server memory higher then going home while the server admin adds more memory? Or the VM admin configures more memory, etc?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1490782
Posted Tuesday, September 03, 2013 1:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 6:14 AM
Points: 37, Visits: 237
Thank you!
Post #1490785
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse