DBCC PAGE read page from buffer pool or directly from the file system?
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.