Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've read about SQL Server buffer cache and various discussions about tuning it, using the Maximum and Minimum Memory settings. But I have a doubt: the operational system has a disk reading cache too. If I use a Maximum Memory way below the available operational system memory, would the operational system cache the disk pages and make its next retrieval faster?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

From this KB:

SQL Server opens database files by using FILE_FLAG_NO_BUFFERING == true. Some utilities and services, such as Analysis Services, use FILE_FLAG_NO_BUFFERING == false.

In other words SQL Server (engine) disables OS disk caching, so lowering the amount of memory SQL Server uses will leave more memory available to the OS and will not be used for windows caching. SQL Server's buffer cache is much more sophisticated and suited to the job of caching sql server data then windows disk read caching.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.