Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05
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.