MSSQL DB 정보 (용량) 및 TABLE 용량, 건수 확인 Query

-- DB 정보

?

1	sp_helpdb 'Database명칭'

-- TABLE 용량

?

1 2 3 4 5 6 7 8 9 10 11

SELECT CONVERT(VARCHAR(30), MIN(o.name)) AS t_name      , LTRIM(STR(SUM(reserved) * 8192.0 / 1024.0, 15, 0) + ' KB') AS t_size FROM   sysindexes i            INNER JOIN sysobjects o ON o.id = i.id WHERE  i.indid IN (0, 1, 255)    AND o.xtype = 'U' GROUP BY        i.id ORDER BY        -- t_name ASC        SUM(reserved) * 8192.0 / 1024.0 DESC

-- TABLE 건수

?

1 2 3 4 5 6 7 8

SELECT o.name      , i.rows FROM   sysindexes i            INNER JOIN sysobjects o ON i.id = o.id WHERE  i.indid < 2    AND o.xtype = 'U' ORDER BY        i.rows DESC

출처 :惡보리 :: MSSQL DB 정보 (용량) 및 TABLE 용량, 건수 확인 Query (tistory.com)