Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBCC Page Expand / Collapse
Author
Message
Posted Thursday, December 20, 2012 7:44 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 12, 2014 10:34 AM
Points: 81, Visits: 265
Hi,

I'm using DBCC Page to investigate data on specific pages. My question is: Does DBCC Page show pages that are in the cache, or pages on disk, or both please?

Thanks
Post #1398977
Posted Thursday, December 20, 2012 7:52 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 39,980, Visits: 36,347
It can read any page that is in the database. Like with all other operations that read pages, it will read the page from cache. If the page isn't in cache, it's brought into cache first and then read.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1398980
Posted Thursday, December 20, 2012 7:59 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 12, 2014 10:34 AM
Points: 81, Visits: 265
That makes sense, thanks for your help.
Post #1398986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse