August 30, 2023 at 1:06 pm
Yes !
ref: Database instant file initialization
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 30, 2023 at 2:59 pm
Posting to get Johan's answer to show up. It was the first post on a new page and this forum still has the problem of not showing the first post of a new page until a second post appears on the new page.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 30, 2023 at 4:22 pm
Johan already said it, but you need to avoid auto growth, not embrace it. It is a problem that auto growth is taking too long, but the bigger problem is the frequency that it seems to be happening. IFI can decrease auto growth time but it also poses some security problems if you are not using TDE. Additionally, for the log file IFI only works up to relatively small increments which could leave you with very high VLF counts if you configure the autogrowth small enough to be able to use IFI.
August 31, 2023 at 5:45 am
Did we mention that autogrow should never be in percentages ! ( as the size of the growth gets larger every time it is executed )
If want to enable autogrowth, have it grow with 1GB at a time.
That should be sufficient to get a dba informed he forgot to extend the file up front and needs to talk with the data owner to see if everything still meets expectations
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 31, 2023 at 1:56 pm
Yes, never in percentages.
Can we track database growth rates over a period of time and then extend datafiles (before autogrowth happens) based on the growth rates ?
August 31, 2023 at 3:46 pm
You can, but the easy way for size checking is to look at backups. For logs, look at the size growth and then ensure your log has that size + a pad in case some log backups might fail.
For data, look at the backup file sizes and ensure you account for the average growth over some time period. I'd do this quarterly, though you could make this a monthly check
September 8, 2023 at 7:33 am
Per Johan Bijnens ...Based on the database growth rate ... extending the datafile by that number. Is this the easiest way to avoid these alerts proactively.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply