Get Database info

  • oradbguru

    Hall of Fame

    Points: 3121

    Comments posted to this topic are about the item Get Database info

  • iquittner

    Grasshopper

    Points: 19

    I tried running this on SQL 2012 and it didn't return anything... Looked a bit deeper and noted that the master.sys.master_files has no records. Any ideas?

  • Lee Linares

    SSCrazy

    Points: 2685

    David,

    Excellent script. Thanks for posting.

    One small point though; the size for tempdb that is found in master.sys.master_files is the NOT the actual size. It is the size that tempdb will be when SQL Server is restarted.

    Thanks again.

    Lee

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Lee Linares (1/21/2014)


    David,

    Excellent script. Thanks for posting.

    One small point though; the size for tempdb that is found in master.sys.master_files is the NOT the actual size. It is the size that tempdb will be when SQL Server is restarted.

    Thanks again.

    Lee

    Thanks for pointing that out.

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

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