Track long running DBCC CHECKDB in SQL Server скачать в хорошем качестве

Track long running DBCC CHECKDB in SQL Server

In this session I will show how to track long running DBCC CHECKDB by using extended events. By using this method, you can track whether DBCC CHECKDB is running or not, whether it is waiting for latches, how many IOs it is doing, what command is running at what time etc. Command to create EX event: =============== CREATE EVENT SESSION [CheckDB_Events] ON SERVER ADD EVENT sqlserver.check_phase_tracing( ACTION(sqlserver.database_id,sqlserver.database_name)), ADD EVENT sqlserver.check_thread_message_statistics( ACTION(sqlserver.database_id,sqlserver.database_name)), ADD EVENT sqlserver.check_thread_page_io_statistics( ACTION(sqlserver.database_id,sqlserver.database_name)), ADD EVENT sqlserver.check_thread_page_latch_statistics( ACTION(sqlserver.database_id,sqlserver.database_name)), ADD EVENT sqlserver.databases_dbcc_logical_scan( ACTION(sqlserver.database_id,sqlserver.database_name)) ADD TARGET package0.event_file(SET filename=N'c:\temp\sql_checkdb.xel') 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=ON,STARTUP_STATE=OFF) GO ===============