Post reply

Temp Db size values from different tables

  • May 25, 2015 at 12:56 am

    #300957

    For finding size values of temp database:

    select * from sys.master_files -

    size column value here is 1024 for .mdf,size here for .ldf is 64

    select * from tempdb.sys.database_files -

    size column value here is 3576 for .mdf,size here for .ldf is 224

    Why is there a difference and not the same.

    size columns in the above 2 tables for temp db's do they represent different values ?

    Thanks

  • May 25, 2015 at 1:26 am

    #1800339

    Master files shows the default size, database files shows the actual size. Only TempDB resets to default size on server start.

    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

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

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