December 11, 2008 at 12:43 pm
hi friends,
i had create a maintenance plan on sqlserver2005 for reindex which will run every sunday evening. in one table 5 noncluster indexs has been created. before reindexing my database size is 50 GB but after reindex my db size is around 185 GB. i dont what goes wrong to db. please help me out
December 11, 2008 at 1:06 pm
On the reindex task - what is the setting you put for 'Change free space per page percentage to:'?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 10:28 am
Is it your log file that's increased in size rather than your data file?
December 16, 2008 at 5:30 am
Check out whether its the date file which has increased or a log file....
If its a log file, this is due to the rebuild index task. Change the Recovery model to Bulk Logged recovery model whenever this task is performed...
December 18, 2008 at 11:57 am
Hi guys
data file is increasing and i got the root cause. this is due Fill factor is set to 10%. So i just set to 90% and i have exeucted the rebuild script again and finally all the indexes has been rebuilded and data file has been compressed.
Thank & regards
Vinodk
December 18, 2008 at 8:54 pm
As a general rule of thumb 100% FILL FACTOR benefits the read activity but slow downs the write activity. As a general rule of thumb, 100% Fill factor for no activity at all, 90% for low activity, 70% for medium activity, 50% for higher activity or lower for more
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply