SELECT CAST(SUM(MaxPerm)/1024.00/1024.00/1024.00/1024.00 as DECIMAL (6,2)) as MaxPerm_TB, CAST(SUM(CurrentPerm)/1024.00/1024.00/1024.00/1024.00 as DECIMAL (6,2)) Currentperm_TB, CAST((SUM(MaxPerm)/1024.00/1024.00/1024.00/1024.00 -SUM(Currentperm)/1024.00/1024.00/1024.00/1024.00) as DECIMAL (6,2)) as Freeperm_TB, CAST(((SUM (CurrentPerm (float)))/ NULLIFZERO (SUM(MaxPerm (float))) * 100.0) as DECIMAL (5,3)) as percent_used FROM DBC.DiskSpaceV;
Check space in particular database SELECT DatabaseName, CAST(SUM(MaxPerm)/1024/1024/1024 as DECIMAL (6,0)) as MaxPerm_GB, CAST(SUM(CurrentPerm)/1024/1024/1024 as DECIMAL (6,0)) Currentperm_GB, CAST((SUM(MaxPerm)/1024/1024/1024 -SUM(Currentperm)/1024/1024/1024) as DECIMAL (6,0)) as Freeperm_GB, CAST(((SUM (CurrentPerm (float)))/ NULLIFZERO (SUM(MaxPerm (float))) * 100.0) as DECIMAL (5,3)) as percent_used FROM DBC.DiskSpaceV where DatabaseName like '<DATABASE_NAME>' GROUP BY 1
ORDER BY 4 DESC; |