OS cache in Sql Server

Question

Post reply

OS cache in Sql Server

Bhuvnesh

SSC Guru

Points: 59351
More actions
July 29, 2014 at 1:17 am

#288224

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;-)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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, MVP, M.Sc (Comp Sci)
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

MikaS Ten Centuries Points: 1210 More actions · Answer 2

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[/url]

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

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;-)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

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, MVP, M.Sc (Comp Sci)
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