March 27, 2015 at 7:49 am
I am monitoring the data file growth of the databases in a table. Every week I review to see how much space is left on each database. I am thinking of writing a query where the current free space left is less than 20% of the file size, it sends out an alert to me, so that I can manually resize the file . Is it a good practice to resize the data file manually? If so I believe this need to be done at the time when the server is least busy since it can slow down the database.
Also do I need to re-index the tables once the data file is resized?
Thanks
March 27, 2015 at 9:33 am
what do you mean by "resizing the data file" ?
March 27, 2015 at 9:41 am
Yes, expand the files manually if you can, at a time of low activity. I would recommend that you leave auto-grow enabled, in case of any unexpected rapid growth. You only need to reindex after shrinking.
John
March 27, 2015 at 12:43 pm
sorry, I meant expanding
March 27, 2015 at 12:43 pm
John Mitchell-245523 (3/27/2015)
Yes, expand the files manually if you can, at a time of low activity. I would recommend that you leave auto-grow enabled, in case of any unexpected rapid growth. You only need to reindex after shrinking.John
Thanks!
March 27, 2015 at 3:05 pm
John Mitchell-245523 (3/27/2015)
Yes, expand the files manually if you can, at a time of low activity. I would recommend that you leave auto-grow enabled, in case of any unexpected rapid growth. You only need to reindex after shrinking.John
Yes, do leave autogrow enabled just in case, but with sensible parameters (not with a small percentage growth).
Tom
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply