Get Database info

• oradbguru

  Hall of Fame

  Points: 3126

  More actions

  January 20, 2014 at 10:26 pm

  #288618

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

• iquittner

  Grasshopper

  Points: 19

  More actions

  January 21, 2014 at 7:50 am

  #1681924

  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: 2730

  More actions

  January 21, 2014 at 8:29 am

  #1681958

  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

  More actions

  April 27, 2016 at 1:47 pm

  #1875062

  Thanks for the script.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  April 27, 2016 at 1:47 pm

  #1875063

  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.