tempdb file read/write i/o 기록 확인

-- 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