'SQL SERVER' 카테고리의 다른 글
| 링크드 서버(linked Server) (0) | 2018.10.26 |
|---|---|
| Linked Server 연결 테스트(TEST) (0) | 2018.10.26 |
| Find Missing Index (0) | 2018.10.26 |
| 서비스팩(SERVICE PACK) 제거 (0) | 2018.10.26 |
| 현재 Transaction Log를 사용중인쿼리 확인 (0) | 2018.10.26 |
2018. 10. 26. 21:49
SQL SERVER
SELECT
DB_NAME() AS 'DB 명'
,d. name AS '파일그룹명'
,e. tSize AS '전체사이즈(mb)'
,SUM( used_page_count)*8 /1024.0 AS '현재사이즈(mb)'
,e. tSize-SUM (used_page_count)* 8 /1024.0 AS '남은사이즈(mb)'
,cast(( SUM(used_page_count )*8/ 1024.0)*100 /e. tSize AS DECIMAL( 10,2 ))AS '사용량(%)'
FROM sys .objects AS a JOIN sys.dm_db_partitiON_stats AS b
ON a .object_id = b .object_id
JOIN sys .sysindexes AS c
ON a .object_id = c .id
AND b .index_id = c .indid
JOIN sys .filegroups AS d
ON c .groupid = d .data_space_id
JOIN ( SELECT data_space_id ,SUM( size)*8 /1024.0 AS 'tSize'
FROM sys .databASe_files WHERE data_space_id <> 0 GROUP BY data_space_id) AS e
ON d .data_space_id = e .data_space_id
GROUP BY d. name,c .groupid, e.tSize