Skip to content

Instantly share code, notes, and snippets.

@kr153

kr153/DATABASE SIZE OF ALL DB IN AN INSTANCE

Created December 10, 2018 06:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kr153/74991b98aa2c27a961ffe0fe07bb654d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kr153/74991b98aa2c27a961ffe0fe07bb654d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DATABASE SIZE OF ALL DB IN AN INSTANCE
with fs
as
(
select database_id, type, size * 8.0 / 1024 size
from sys.master_files
)
select
name,
(select sum(size) from fs where type = 0 and fs.database_id = db.database_id) DataFileSizeMB,
(select sum(size) from fs where type = 1 and fs.database_id = db.database_id) LogFileSizeMB
from sys.databases db ORDER BY DataFileSizeMB DESC, LogFileSizeMB DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment