Quick check server space and DB size

• joeroshan

  SSChampion

  Points: 10377

  More actions

  August 18, 2016 at 3:57 pm

  #329229

  Comments posted to this topic are about the item Quick check server space and DB size

  ----------------------------------------------------------------------------------------------------------------------------------------------------
  Roshan Joe

  Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  September 20, 2016 at 6:49 am

  #1901840

  Seems to work fine. Thanks.

• rw_ebox

  Right there with Babe

  Points: 797

  More actions

  September 20, 2016 at 9:29 am

  #1901923

  It is a great script and I modified your script below.

  Select

  volume_mount_point,

  CAST(ROUND(max(vs.total_bytes)/1024.0/1024/1024, 2) as numeric(16,2)) TotalSpaceGB ,

  CAST(ROUND(min(available_bytes)/1024.0/1024/1024, 2) as numeric(16,2)) FreespaceGB ,

  Count(*) as DBFileCount

  from sys.master_files S cross apply Sys.dm_os_volume_stats(s.database_id,s.file_id) vs Group by volume_mount_point

  Go

  Select

  db_name(database_id) DBName,

  CAST(ROUND(size*8.0/1024, 2) as numeric(16,2)) as SizeMB,

  Physical_Name,

  Name as Logical_Name

  from sys.master_files order by size Desc

  Go

  Thank you for your sharing!