Zain, our brilliant analyst software engineer from Karachi has done his homework!
Answer to yesterday's post is;
"DCM"(Differential-Changed-Map) pages.
Differential backups read just the DCM pages to determine which extents have been modified. This greatly reduces the number of pages that a differential backup must scan. The length of time that a differential backup runs is proportional to the number of extents modified since the last BACKUP DATABASE statement and not the overall size of the database. The interval between DCM pages and BCM pages is the same as the interval between GAM and SGAM page, 64,000 extents. The DCM and BCM pages are located behind the GAM and SGAM pages in a physical file.
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment