Database snapshots in SQL Server 2005 Enterprise Edition give you a consistent view of a database as of a certain point in time. The database snapshot appears to you as a read-only static database. You can create multiple database snapshots on a source database. You can revert the source database to an earlier state by restoring it from a database snapshot.
Database snapshot performance is closely tied to the I/O capabilities of the system. This white paper summarizes the results of testing database snapshot performance under intense I/O activity on a large database. We measured the impact of creating a single database snapshot and multiple database snapshots under varying transaction loads as well as the performance effect of database snapshots on index creation and rebuild. This white paper provides some best practice recommendations for using database snapshots under I/O-intensive conditions.
Posts
0 comments:
Post a Comment