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

15 votes168 views2 answers
How to drop database name in postgresql
SQL
0 vote224 views1 answer
Mysql multiple group by
SQL
0 vote190 views1 answer
Psql no such file or directory
SQL
0 vote185 views1 answer
Django mssql backend
SQL
0 vote138 views1 answer
Login phpmyadmin without password
SQL
2 votes168 views1 answer
Oracle find constraints referencing a table
SQL
21 votes167 views6 answers
Change column in mysql
SQL
0 vote177 views1 answer
How to check common records in 2 table
SQL
29 votes168 views5 answers
Mysql show table structure
SQL
0 vote166 views1 answer
Mariadb current date plus 1 day
SQL