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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy