Apr 11, 2018

Get databases size in sql server(데이터베이스 용량 추출하기 MS SQL)

SELECT 
SYS.DATABASES.NAME,
CONVERT(VARCHAR,SUM(SIZE)*8/1024)+' MB' AS 'DATABASE SIZE'
FROM     SYS.DATABASES 
JOIN SYS.MASTER_FILES 
  ON SYS.DATABASES.DATABASE_ID=SYS.MASTER_FILES.DATABASE_ID 
GROUP BY SYS.DATABASES.NAME 
ORDER BY SYS.DATABASES.NAME

No comments:

Post a Comment