Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    1

    space available for database 0.00MB

    Hi

    Please help me in resolving the proble.

    Database properties showing space available for database is 0.00mb
    physical available space on HDD is around 32 GB... Db size is 5gb...but im bit worried about the size what is being displayed....
    Settings in my database

    General
    1) Size of db: 14306.45MB
    2) Space available: 0.00MB

    Data Files
    1) Automatically grow file
    2) File growth By Percent: 10
    3) Maximum file size: Unlimited file growth

    Transaction log
    1) Automatically grow file
    2) File growth By Percent: 10
    3) Maximum file size: Unlimited file growth

    Options
    1) AutoShrink
    I'm worried about this "space available: 0.00MB". What kind of impact will it create?
    If I set all settings to unlimited file growth, does it mean my database can grow as big as my physical harddisk space allows? Does this also means I do not have to worry about database allocation?

    Please help me

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,634
    Don't use % for file growth.
    Preallocate the data and log sizes based on estimated growth (that's a homework that developer and DBA need to do while planning the implementation) to minimize the impact on performance when additional growth is required.
    Don't over-allocate because this will impact your backup size and duration.
    Always set the limit to grow, otherwise you'll get a suspect status (at a minimum), or even worse, - server will not start, depending on what database runs to the disk limit first.
    Autoshrink has issues related to SAN or very fast IO subsystem, so turn it off, you're not gaining anything having it on.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •