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.

  • It would query various system pages(GAM,SGAM,PFS) to get the information I believe – Shanky Nov 16 '16 at 12:12
  • Get the information from where? buffer pool or disk? – Just a learner Nov 16 '16 at 12:14
  • I believe information would always be read from buffer pool. – Shanky Nov 16 '16 at 12:17
  • 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 '16 at 12:39
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.