DMV를 사용해서 tempdb 공간 사용 현황을 확인할 수 있다.
SELECT
SUM (user_object_reserved_page_count)*8 AS user_objects_kb,
SUM (internal_object_reserved_page_count)*8 AS internal_objects_kb,
SUM (version_store_reserved_page_count)*8 AS version_store_kb,
SUM (unallocated_extent_page_count)*8 AS freespace_kb
FROM
sys.dm_db_file_space_usage
WHERE
database_id = 2;
GO
'SQL Server > Tips' 카테고리의 다른 글
SQL Server DBCC CHECKDB (0) | 2012.07.30 |
---|---|
SQL Server COALESCE 함수 (0) | 2012.07.26 |
SQL Server KILL WITH STATUSONLY 옵션 (0) | 2012.07.26 |
링크 (0) | 2012.07.19 |
CPU, I/O Bottleneck 찾기 (0) | 2011.03.25 |