모든 데이터베이스 전체 공간 및 여유 공간 조회
use tempdb go CREATE TABLE DBO.TBL_DB_SIZE ( ID INT IDENTITY, NAME NVARCHAR(100), RSVD NVARCHAR(50), DATA NVARCHAR(50), INDX NVARCHAR(50), UNUS NVARCHAR(50) ) EXEC SP_MSFOREACHDB ' USE [?] declare @id int -- The object id that takes up space ,@type character(2) -- The object type. ,@pages bigint -- Working variable for size calc. ,@dbname sysname ,@dbsize bigint ,@logsize bigint ,@reservedpages ..
더보기
[MSSQL] 2005 이상 LOCK MONITORING
SELECT total_elapsed_time, 'Holder' WaitType, command, blocking_session_id, session_id, status, logical_reads, wait_type, wait_time, last_wait_type, wait_resource, text FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t WHERE session_id IN (SELECT blocking_session_id FROM sys.dm_exec_requests WHERE blocking_session_id>0) AND blocking_session_id=0 UNION ALL SELECT total_..
더보기
