March 10, 2007 at 9:13 pm
I'm changing options for several databases so they use a different recovery mode (i.e. full -> simple). I'm also changing them so they no longer use 'auto update statistics'.
After adjusting these settings, should I be doing anything else to make these changes take effect?
I'm noting that in some cases these databases have grown at a much faster rate than expected. Everything in the Properties -> Files section for the older, smaller initial size a 10% growth rate. Should I consider updating these initial values and the related growth rates? What should I use to estimate sizes of logs and growth rates for data and logs?
March 10, 2007 at 11:33 pm
Before changing the recovery model read the BOL topic RECOVERY MODELS because it is going to effect your database point in time recovery...
If you are disabling the auto update statistics...make you run update statistics atleast once a day off peak hours otherwise optimizer will generate inefficient plan...
http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
Initial values you may need to change depends the db usage and requirements....
I will prefer to use db growth in MB for large dbs instead of %....
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply