Skip to content

Instantly share code, notes, and snippets.

@yang-qu

yang-qu/db_size.sql

Created December 5, 2016 03:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save yang-qu/b3400dfb2d43549c12ad8cb5c0ea82f9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save yang-qu/b3400dfb2d43549c12ad8cb5c0ea82f9 to your computer and use it in GitHub Desktop.
Download ZIP
get sql server db size
Raw
db_size.sql
SELECT
database_name = DB_NAME(database_id)
, log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))
FROM sys.master_files WITH(NOWAIT)
--WHERE database_id = DB_ID() -- for current db
GROUP BY database_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment