1

We know that SQL Server always read pages from disk to memory for all its operations. So it's possible that a page in memory is different from it's counterpart in disk. I want to know the command DBCC PAGE is reading a page in memory or on disk. Thanks.

1
  • It is better to say SQL Server always uses memory for all of it's operations and retrieves data from disk only if not already in memory. Execute CHECKPOINT; DBCC DROPCLEANBUFFERS; to ensure they are the same.
    – Dan Guzman
    Nov 16, 2016 at 12:39

1 Answer 1

2

We know that SQL Server always read pages from disk to memory for all its operations.

The pages are asked for from memory like most things in SQL Server. The same process applies for DBCC PAGE as it does for other read operations in SQL Server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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