-- Read I/O
CREATE EVENT SESSION [MONITOR_FILEIO_READ_HISTOGRAM]
ON SERVER
ADD EVENT sqlserver.file_read
( SET collect_path = (1)
WHERE
( -- tempdb 드라이브 path를 지정
[sqlserver].[like_i_sql_unicode_string]([path],N'E:\%')
)
)
ADD TARGET package0.histogram
( SET filtering_event_name = N'sqlserver.file_read'
, source = N'path'
, source_type = (0)
)
WITH
( max_memory = 4096 kb
, event_retention_mode = allow_single_event_loss
, max_dispatch_latency = 30 seconds
, max_event_size = 0 kb
, memory_partition_mode = none
, track_causality = off
, startup_state = off
)
GO
-- Write I/O
CREATE EVENT SESSION [MONITOR_FILEIO_WRITTEN_HISTOGRAM]
ON SERVER
ADD EVENT sqlserver.file_written
( SET collect_path = (1)
WHERE
( -- tempdb 드라이브 path를 지정
[sqlserver].[like_i_sql_unicode_string]([path],N'E:\%')
)
)
ADD TARGET package0.histogram
( SET filtering_event_name = N'sqlserver.file_written'
, source = N'path'
, source_type = (0)
)
WITH
( max_memory = 4096 kb
, event_retention_mode = allow_single_event_loss
, max_dispatch_latency = 30 seconds
, max_event_size = 0 kb
, memory_partition_mode = none
, track_causality = off
, startup_state = off
)
GO
'연구개발 > DBA' 카테고리의 다른 글
RECOMPILE (0) | 2015.09.04 |
---|---|
tempdb 대량 I/O 발생시키는 쿼리 확인 (0) | 2015.09.01 |
tempdb 많이 사용하는 실행계획과 텍스트 반환 (0) | 2015.08.31 |
SQL Server 메모리 (0) | 2015.06.04 |
LATCH (0) | 2015.06.03 |