What’s a Snapshot?

What are snapshots and what are their benefits and drawbacks?

There are multiple types of snapshot (e.g., snapshot replication, database snapshot, snapshot isolation level). I assume you mean database snapshots, which are designed to present a point-in-time, read-only copy of a database. Snapshots are especially-beneficial when you're using report suites that need a stable view of the data. As data changes, the original pages are added to the snapshot. This process, also known as "copy on right," can cause the performance of a database snapshot to decline slightly over time.

—Patrick Conlan
Platform Program Manager
Microsoft Project Team

 

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish