April 18, 2011 at 5:37 am
Hi,
We've had a number of problems recently with applications which access data via a SQL 2005 database snapshot running slowly. These snapshots are updated daily as new data is brought into the system.
Running sp_updatestats hasn't fixed this initially, however running this followed by recreating the snapshot has resolved the performance issue.
My question is - can running sp_updatestats improve the performance of a snapshot, or does the snapshot need to be recreated for the updated stats to take effect.
regards,
Ian Harris.
April 18, 2011 at 9:47 pm
A database snapshot contains the data as it was when the snapshot was created. This applies to all things in the database including system objects. So, updating statistics will not change the performance of queries running against the snapshot.
As you have found, you need to re-create the snapshot for the statistics to be used.
April 19, 2011 at 1:50 pm
Thanks very much for that. That confirms what we suspected.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply