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 assigned to the OS Expand / Collapse
Author
Message
Posted Thursday, September 26, 2013 4:46 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:50 AM
Points: 299, Visits: 1,129
Total physical RAM on the system is 288GB.
Min and Max memory assigned to SQL Server is 0 and 280GB.
Should I assume that 8GB is assigned to the OS? Is there a way to verify the amount of memory assigned to the OS?
Post #1499106
Posted Thursday, September 26, 2013 5:28 PM


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 @ 1:43 PM
Points: 40,411, Visits: 36,861
There's no memory 'assigned' to the OS. 8GB is what SQL is leaving for the OS and any other app running on that server. That's rather a high figure for max server memory for that much memory.

Chapter 4: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/



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 #1499114
Posted Friday, September 27, 2013 11:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:50 AM
Points: 299, Visits: 1,129
GilaMonster (9/26/2013)
There's no memory 'assigned' to the OS. 8GB is what SQL is leaving for the OS and any other app running on that server. That's rather a high figure for max server memory for that much memory.

Chapter 4: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/


Ok.
It was written in this book that "
As a general base configuration, for a dedicated SQL Server machine, reserve 1 GB of RAM
for the OS, 1 GB for each 4 GB of RAM installed from 4–16 GB, and then 1 GB for every 8
GB RAM installed above 16 GB RAM. This means that, for a server with 64 GB RAM, the
starting point for max server memory should be in the 54 GB range, and then tuned
higher based on monitoring the Memory\Available Mbytes performance counter."


Gail, please correct me if I'm wrong-- I'm thinking the max SQL server memory setting would be 250GB.
Post #1499531
Posted Wednesday, October 2, 2013 11:19 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:54 PM
Points: 1,569, Visits: 2,631
..It's ideal. But it's definitely depended on what other applications you have in the box as well...
Post #1500862
Posted Wednesday, October 2, 2013 11:20 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:54 PM
Points: 1,569, Visits: 2,631
Edit --- Posted for wrong question..
Post #1500863
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse