I have found this query valuable. Sometimes you need to see just overall consumption without any detailed information. It is also useful in overall trend analysis and disk space planning.
2019-08-16
608 reads
Disk space used by the SQL Server instance
select (8.0*sum(size))/1024/1024 TotalGB from sys.master_files;
Related content
2019-08-01
918 reads
2019-07-23
5,753 reads
2020-07-24 (first published: 2018-12-27)
4,072 reads
Logshipping to SQL Server on Linux
An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.
2020-06-25 (first published: 2018-06-05)
1,713 reads