Mssql show database size

Get all db sizes in mysql server

SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Source: stackoverflow.com

Mssql show database size

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

Source: stackoverflow.com

Similar codes

0 vote283 views1 answer
Get only one row in mysql
SQL
0 vote293 views1 answer
Amount of entries in a table psql
SQL
0 vote250 views1 answer
Mysql group by derived column
SQL
0 vote314 views1 answer
Sql values that contains certain multiple ids
SQL
-1 vote262 views1 answer
Mysql #1064 error
SQL
0 vote265 views1 answer
Install sql server in ubuntu 20.04
SQL
7 votes291 views2 answers
Phpmyadmin change password
SQL
0 vote258 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote277 views1 answer
Sql server get date of previous sunday
SQL
1 vote274 views2 answers
Oracle difference between two dates in seconds
SQL