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

1 vote121 views1 answer
How to see logical reads in sql server
SQL
1 vote127 views1 answer
Mysql date diff in seconds
SQL
6 votes137 views2 answers
Sql query to get the number of rows in a table
SQL
9 votes115 views2 answers
Get first 3 letters in sql
SQL
7 votes223 views2 answers
Sql empty table
SQL
5 votes117 views1 answer
Sysdate in oracle sql
SQL
0 vote130 views1 answer
Mysql beautifier terminla
SQL
0 vote120 views1 answer
Oracle SQL join three tables and group by column
SQL
49 votes214 views6 answers
Install mysql ubuntu
SQL
22 votes122 views4 answers
Show list of users in mysql
SQL