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

OS cache in Sql Server Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 1:17 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:36 AM
Points: 2,840, Visits: 3,970
Does Sql server use OS cache (outside buffer cache) for its operations ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1597170
Posted Tuesday, July 29, 2014 9:58 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 @ 3:37 PM
Points: 40,210, Visits: 36,619
What exactly do you mean by 'OS cache'?

SQL uses memory outside of the buffer pool, but it's no the OS's memory, it's SQL's memory.



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 #1597378
Posted Wednesday, July 30, 2014 2:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 12:33 PM
Points: 38, Visits: 561
Hi,

OS System Cache is a subset of a Standby List. Standby List is used for pages that have not been touched for awhile and Windows performed memory trimming on them. Also when the process (like sqlservr.exe) is terminated the pages for the exe and the dll's have their pointers updated to point to the Standby List, so that they can be re-assembled from the cache.

Standby List is one of the four lists used by the OS to organize physical memory. They're used by the OS, services, applications etc, so in that regard it can be said that they're also used by the SQL Server :)


Mika Sutinen, Senior DBA
@SQLFinn on Twitter
Blogging at SQLStarters
Post #1597618
Posted Wednesday, July 30, 2014 3:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:36 AM
Points: 2,840, Visits: 3,970
MikaS (7/30/2014)
Hi,

OS System Cache is a subset of a Standby List. Standby List is used for pages that have not been touched for awhile and Windows performed memory trimming on them. Also when the process (like sqlservr.exe) is terminated the pages for the exe and the dll's have their pointers updated to point to the Standby List, so that they can be re-assembled from the cache.

Standby List is one of the four lists used by the OS to organize physical memory. They're used by the OS, services, applications etc, so in that regard it can be said that they're also used by the SQL Server :)
thanks any areticle link ..actually i didnt find any.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1597635
Posted Wednesday, July 30, 2014 3:56 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 @ 3:37 PM
Points: 40,210, Visits: 36,619
Google for mark russinovich windows memory and you'll find a tonne of stuff. That's OS-level memory management though, not SQL's memory management.


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 #1597638
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse