confusion about Database file size

  • I have some confusion about the following concepts in a database property:

    In SSMS, when right click a database, for example Model.

    1. General tab:

    Size: 3.75 MB

    Space availabl: 1.14 MB

    2. FileS tab:Modeldev Initial Size: 3 MB

    Modlelog Initial size: 2 MB

    3. When click Shrink file screen: (I don't really shrink them, but just look at the size info on this screen)

    Data: Currently allocated space: 2.25 MB, Available free space: 0.88MB (38%)

    Log: Currently allocated space: 1.50 MB, Available free space: 0.05MB (3%)

    I don't understand in 2 above, the intial size is 3+2 = total 5 MB.

    But why in 1 the totoal of database is 3.75 MB?

    What does initial mean here?

  • When you right click and view the DB size it includes the log file and is a rounded number (which you know). The space shown in the properties tab shows you the exact amount (not rounded) of space used (not necessarily available), this amount is the sum of the "currently allocated space" of both the log and data files.

    It's appearing off because of the rounding

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • MyDoggieJessie (1/22/2013)


    When you right click and view the DB size it includes the log file and is a rounded number (which you know). The space shown in the properties tab shows you the exact amount (not rounded) of space used (not necessarily available), this amount is the sum of the "currently allocated space" of both the log and data files.

    It's appearing off because of the rounding

    I am not sure I understand you.

    I don't see an option when you say: When you right click and view the DB size

    Also can you answer my question about initial size?

  • sqlfriends (1/22/2013)


    MyDoggieJessie (1/22/2013)


    When you right click and view the DB size it includes the log file and is a rounded number (which you know). The space shown in the properties tab shows you the exact amount (not rounded) of space used (not necessarily available), this amount is the sum of the "currently allocated space" of both the log and data files.

    It's appearing off because of the rounding

    I am not sure I understand you.

    I don't see an option when you say: When you right click and view the DB size

    Also can you answer my question about initial size?

    I believe, he meant to say right click database then under files tab, you see the data and log size, if you add those 2 together, it should give you the total size of database.

    As far as initial size, it gets a default size when you initially create the database. You can change it manually if you want, once the initial size is fully used, SQL will request for more space depends on the growth factor. Hope it helps and if I mentioned anything wrong, please someone correct me. These are my understanding so, I could be wrong.

    SueTons.

    Regards,
    SQLisAwe5oMe.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply