December 3, 2007 at 7:01 am
We have a large database in one file group (one File) that is 250GB in size. The weekly maintenance plan that is scheduled runs the update statistics at 20% sampling. The problem is that it take 11 hours to run. How does one shorten the optimixation (update statistics) scheduled job? It does the entire database and it is used as a Data repository. data gets inserted 24 hours a day but there are no deletes or updates.
Any help would be appreciated, thanks!
December 3, 2007 at 10:43 am
Depending on the requirements
you could split the statisticsupdate over 2 days.
Using a cursors to loop through the objects and applying
UPDATE STATISTICS.
You could also reduce the sample size.
December 7, 2007 at 12:49 pm
Ok I'll try 5% on a 250Gb database.
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