Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05
Question; how does a snapshot database perform compared to the original database when it comes to querying – can it make use of the indexes on the original database?
Thanks to my colleague in the States, Lewis Bruck, I can confirm that all pages in the database (including index pages) are available to the snapshot database.
Query performance on the snapshot compared to the original database depends on a number of factors: the snapshot is read-only, so fewer locks are obtained, but copied data can introduce disk fragmentation requiring more read costs.