October 28, 2004 at 4:03 am
Are there any negative implications of over allocation of data file and trans log space?
We have SAN attached devices and the DBA's routinely allocated 10Gb and 5Gb for the files respectfully (sic) even though requirement are very unlikely to exceed a few Gb.
Environment: SQL Server 2000 EE Cluster.
Any thoughts gratefully received.
October 28, 2004 at 4:25 am
No, none that I'm aware of.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
October 28, 2004 at 5:49 am
October 29, 2004 at 8:55 am
I don't see any either. For checking growth patterns, you can always look at backup sizes to monitor growth patterns.
October 29, 2004 at 12:21 pm
We always try to preallocate to cut down on unchecked filegrowth. We have some databases with double the amount of currently used data allcoated so we don't grow the datafiles at all over the next year if we don't have to. You want to be careful and not waist a ton of space if you dont' have to but I dont' think they are hurting anything by allocating enough space up front plus some for growth.
Wes
November 3, 2004 at 9:21 am
OK. Thanks for all your input. Much appreciated. I'll consider this post closed.
Regards
Derek
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply