DEFINITIONS

Definitions More Info.
Definition ID11.058
TitleSQL
CategoryNOTES
Definitionserverdaki tum database size boyut
Definition Descriptionhttps://sqlconjuror.com/sql-server-get-size-of-all-databases-in-mb-and-gb/

SELECT d.NAME
,ROUND(SUM(CAST(mf.size AS bigint)) * 8 / 1024, 0) Size_MBs
,(SUM(CAST(mf.size AS bigint)) * 8 / 1024) / 1024 AS Size_GBs
FROM sys.master_files mf
INNER JOIN sys.databases d ON d.database_id = mf.database_id
WHERE d.database_id > 4 -- Skip system databases
GROUP BY d.NAME
ORDER BY d.NAME


https://www.netwrix.com/sql_server_database_size.html

EXEC sp_databases;
RecordBycunay
Record Date24-09-2021 12:07:48
Düzenle
Kopyala
Sil