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 vote188 views1 answer
How to export only procedures mysql
SQL
5 votes219 views1 answer
Add column table sql default value
SQL
10 votes180 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote129 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote189 views1 answer
Get record which is available in one table but not in another mysql
SQL
24 votes167 views5 answers
Sql reset auto increment
SQL
0 vote189 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote179 views1 answer
Call rest api from postgresql
SQL
0 vote176 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote181 views1 answer
Postgres : ERROR: division by zero
SQL