Any Issues with over allocation of space?

  • 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.

     

  • 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]

  • pls check san if any configuration change?


    Kindest Regards,

    karthik

  • I don't see any either. For checking growth patterns, you can always look at backup sizes to monitor growth patterns.

  • 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

  • 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