Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Performance Implications of Database Snapshots RE: Performance Implications of Database Snapshots

  • September 23, 2008 at 2:47 am

    #875490

    Chirag (9/23/2008)

    The pages from the source database get written to the snapshot's sparse file the first time the page gets modified in the source database. Is that right?

    If that's so, does then the performance degradation happen only for the first time a page gets modified.

    If that were the case, then delete performance wouldn't be affected, and neither would update... ??

    ... sorry didn't see that the deletes were on different rows! 🙂

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone