Cacher is the code snippet organizer for pro developers

select f.name as 'Filegroup',
(SUM(size)*100/sum(max_size)) as '% usada' 
from sys.database_files d left join sys.filegroups f
on d.data_space_id=f.data_space_id 
group by d.data_space_id,f.data_space_id,f.name;