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.

Comments (0)

Skip to main content