Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql Server Snaphot Performance. Expand / Collapse
Author
Message
Posted Thursday, October 18, 2012 3:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 12, 2014 10:34 AM
Points: 81, Visits: 265
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.
Post #1374222
Posted Thursday, October 18, 2012 3:40 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 40,258, Visits: 36,681
Yup, it can be due to the snapshot.
http://www.sqlservercentral.com/articles/Performance+Tuning/64080/



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1374225
Posted Thursday, October 18, 2012 3:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 12, 2014 10:34 AM
Points: 81, Visits: 265
Thanks very much for your help. Thats exactly what I needed.
Post #1374232
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse