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 2, 2013 11:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 5:46 AM
Points: 37, Visits: 239
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 3, 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: Today @ 9:05 AM
Points: 42,469, Visits: 35,540
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 3, 2013 12:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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 3, 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: Today @ 9:05 AM
Points: 42,469, Visits: 35,540
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 3, 2013 1:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 5:46 AM
Points: 37, Visits: 239
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 3, 2013 1:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
But why not they check OS Memory before accepting it?



Regards
Durai Nagarajan
Post #1490778
Posted Tuesday, September 3, 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: Today @ 9:05 AM
Points: 42,469, Visits: 35,540
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 3, 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: Today @ 9:05 AM
Points: 42,469, Visits: 35,540
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 3, 2013 1:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 5:46 AM
Points: 37, Visits: 239
Thank you!
Post #1490785
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse