Post reply

calculate database size

  • September 27, 2013 at 1:29 pm

    #298415

    Friends,

    how can i calculate database size with this information:

    Processed 8192240 pages for database 'DBOLTP', file 'rm' on file 1. ??

    (8192240 *8) = 65537920 (bytes) / 1024 / 1024 = 62MB?

    Thanks...

  • September 28, 2013 at 12:22 pm

    #1654306

    Are you looking too deep into a simple problem?

    Would this not provide the answer you need?

    select name, size from sys.master_files;

  • September 29, 2013 at 4:27 pm

    #1654370

    LOVER OF SQL (9/27/2013)

    Friends,

    how can i calculate database size with this information:

    Processed 8192240 pages for database 'DBOLTP', file 'rm' on file 1. ??

    (8192240 *8) = 65537920 (bytes) / 1024 / 1024 = 62MB?

    Thanks...

    Any size given in pages can be converted to binary (1024^3) MB just by dividing by 128.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 29, 2013 at 4:32 pm

    #1654371

    That won't allow you to calculate the size of the database files. It will allow you to calculate the total size of the allocated extents in the database. If you want the size of the files, query sys.database_files.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 7, 2013 at 11:59 am

    #1656462

    Each time I have been asked to return the size of the databases for the systems I manage, I tend to use this query. It returns the size for all databases found in master.

    USE master

    go

    exec sp_helpdb

    Here is the relevant Microsoft Article on it.

  • October 9, 2013 at 12:18 am

    #1656994

    saso_yns (10/8/2013)

    ??? ??? ???? ??????

    ??? ??? ??? ??? ???????

    ??? ??? ??? ??? ??????

    ahhhhh......Everything seems so much clearer now....:-D

  • October 14, 2013 at 5:18 am

    #1658237

    Execute EXEC sp_spaceused towards the database, the reserved size shows the exact size of the database (Even the backup size for the database)

Viewing 7 posts - 1 through 6 (of 6 total)

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