patternsqlMinor
Autogrowth in SQL Server
Viewed 0 times
sqlautogrowthserver
Problem
I ran into some trouble with my disk space on server because my DB size increase. Auto Growth is enable on my database, But file growth is in percentage and not in MB. I want to change in to MB.
But before changing that I want to know can we do this change in working hours or do we require down time for it.
I don't want to take any risk in working hours so I want to be sure before doing this.
But before changing that I want to know can we do this change in working hours or do we require down time for it.
I don't want to take any risk in working hours so I want to be sure before doing this.
Solution
But before changing that I want to know can we do this change in working hours or do we require down time for it
Yes you can change the autogrowth setting when database is being accessed, for next autogrowth instead of percentage the value in MB would be taken into account. Its almost always a good idea to keep autogrowth in MB. You can get tentative value for autogrowth from This Article use the query mentioned to set the tentative value. Keep monitoring using the query in future this value may change then accordingly you have to change yours
I suggest you to read Considerations for the "autogrow" and "autoshrink" settings in SQL Server
Yes you can change the autogrowth setting when database is being accessed, for next autogrowth instead of percentage the value in MB would be taken into account. Its almost always a good idea to keep autogrowth in MB. You can get tentative value for autogrowth from This Article use the query mentioned to set the tentative value. Keep monitoring using the query in future this value may change then accordingly you have to change yours
I suggest you to read Considerations for the "autogrow" and "autoshrink" settings in SQL Server
Context
StackExchange Database Administrators Q#160959, answer score: 4
Revisions (0)
No revisions yet.