Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05

  • Article

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.