There are several ways to find the size of SQL Server databases. However, the easiest method to get the list of all the databases along with their sizes is by using the system stored procedure sp_databases. Here is an example on how to execute this stored procedure and the result.
/* Result */
DATABASE_NAME DATABASE_SIZE REMARKS
DnnDev.me 41280 NULL
master 6592 NULL
model 16384 NULL
msdb 42368 NULL
MtbToolsDB 291840 NULL
SirApp 16384 NULL
SirDB_201804 167552 NULL
tempdb 16384 NULL
Test.MyTecBits.com 24576 NULL
WideWorldImporters 3379200 NULL
NOTE: In this, the size of the database is given in kilobytes. Also, this method will not give you the sizes of log file and data file separately. So, you can use this method to find the database with large size.
Go here for more SQL Server tips.
- More about sp_databases at Microsoft Docs.