Post reply

Question about sys.database_files view size field

  • August 15, 2008 at 9:14 am

    #127104

    In the master database there is a system view named 'sys.database_files' with a field named 'size'.

    I have a database named 'Altiris' where the size equals 83584 for the mdf file and 18288 for the log file in the database_files view.

    In Windows Explorer the size is 668,672 for the mdf and 146,304 for the ldf.

    In Management Studio, on the General tab of the properties windows, the size shows 795.88 MB.

    Can someone explain to me how the 'size' in the system view is determined? What does it mean or represent?

    I want to use the 'size' field from the system view in a report that to monitor database growth.

    Thanks.

  • August 15, 2008 at 9:25 am

    #858821

    Patrick Womack (8/15/2008)

    Can someone explain to me how the 'size' in the system view is determined? What does it mean or represent?

    According to Books Online:

    size: Current size of the file, in 8-KB pages.

    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

  • August 15, 2008 at 9:45 am

    #858834

    Thanks, Gila.

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

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