• 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.