Sql Server Snaphot Performance.

  • Hi,

    I am running an update to a large number of rows on a table in a database which has a snapshot.

    The update is quite slow, so I was just wondering if having a snaphot in place will slow down updates at all, as the original pages will need to be copied to the snapshot for each modification?

    It may just be due to the large amount of data; however I'd like to rule out the possibiltiy that the update is not being slowed down by the snaphot being in place.

    Thanks.

  • Yup, it can be due to the snapshot.

    http://www.sqlservercentral.com/articles/Performance+Tuning/64080/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks very much for your help. Thats exactly what I needed.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply