September 26, 2008 at 8:58 am
To store the copied original pages, the snapshot uses one or more sparse files. Initially, a sparse file is an essentially empty file that contains no user data and has not yet been allocated disk space for user data.
Then how the disk space allocated for the copied original data page in .ss file.
September 26, 2008 at 9:49 am
I'm not sure I understand the nature of your question, but the database engine will automatically add space to the file(s) of the snapshot whenever the first time data on a page is about to change in the original database so it can copy the page before the transaction completes. That's why there is a performance hit that increases with the more snapshots you have on the same database, the engine has to keep checking the snapshots to see if they have the original page copied to them already.
September 26, 2008 at 11:22 am
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply