Sample Header Ad - 728x90

DB autogrowth issue

0 votes
1 answer
186 views
I have a database that will growth in 1 month time the autogrowth was set to 500MB but as I monitored it, the consumption is 1GB+ per day. Should I wait for it to auto grow or is it better to set the initial size to much bigger size? Or set the auto growth to much higher size? Another thing is the timing of expanding the size, is it ok to do it online while there is a production will it have a minimal impact to our production or should I schedule a downtime? Thanks for the response.
Asked by Neil de Rama (1 rep)
Jan 21, 2021, 02:15 PM
Last activity: Jan 21, 2021, 03:11 PM