Technical Article

All database files growth

,

Execute the given script which will provide growth details for each file of the databases.

select DB_NAME(database_id) as Database_name,Name,growth,
case is_percent_growth
when 0 then 'In MB'
when 1 then 'In Percent'
end as Typeofgrowth,
case max_size
when 0 then 'Restricted'
when -1 then 'Unrestricted'
when 268435456 then 'Unrestricted'
else convert(varchar(20),max_size/128)
end as Maxsize
 from sys.master_files

Rate

3 (2)

Share

Share

Rate

3 (2)