question

Button avatar image
Button asked

Can I use disk size to determine database create size?

If one has a disk allocated to the mdf file, for this example a 500GB disk, will it be good practice to reserve 80% of the disk for the initial database size? Same for ldf being given allocated a 500GB disk. Reasoning for this is to eliminate auto growth completely. Still have it enabled, but only having it in place for that 1% chance of it happening.
disk-spacedatabase-sizedisk-usage
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
For the data, sure. If you know that disk is dedicated to that database, you can allocate all the space. It won't hurt anything. For the log, I'd be concerned with having that large a log file. Assuming your running frequent enough log backups if you're in full recovery, your log file can be quite small. Allocating 300gb for a 300gb database just doesn't seem like we've configured things correctly.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
"If you know that disk is dedicated to that database *and that the database will eventually need most of that space*..."
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.