Which target should you use for each session?

DRAG DROP

You must troubleshoot performance issues that users report. You identify the following representative user sessions:

You need to configure the appropriate Extended Events.

Which target should you use for each session? To answer, drag the appropriate Extended Event targets to the correct sessions. Each Extended Event target may be used once, or not at all. You may need to drag the split bar between panes or scroll to view content.

View Answer

Answer:

Session 1: Event Files Event files use to write event session output from complete memory buffers to disk. This is an asynchronous target.

Session 2: Histogram Histogram use to count the number of times that a specified event occurs, based on a specified event column or action. This is an asynchronous target.

Incorrect Answers: ETW: The Extended Events infrastructure supports the correlation of data from SQL Server, and under certain conditions, the correlation of data from the operating system and database applications. In the latter case, Extended Events output must be directed to Event Tracing for Windows (ETW) to correlate the event data with operating system or application event data.

Event Counter: An event counter counts all specified events that occur during an Extended Events session. Use to obtain information about workload characteristics without adding the overhead of full event collection. This is a synchronous target.

References:

https://docs.microsoft.com/en-us/sql/database-engine/sql-server-extended-events-targets?