Script Find DB File Growth for all the databases

Kunal Ranpura
Jul 28, 2019
1 min read

select name, physical_name, size*0.000008 Size_GB, growth, is_percent_growth, growth*0.0078125 Growth_MB from sys.master_files order by is_percent_growth desc

Recent Posts

See All

Find Missing Indexes using Query Store

SELECT SUM (qrs.count_executions) * AVG (qrs.avg_logical_io_reads) as est_logical_reads, SUM (qrs.count_executions) AS...

SQL Server Find Missing Index using Query Store

--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...

SQL Server Profiler Trace

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

Comments