Troubleshoot performance issues by Extended Events
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. Select and Place:
Answer Given: 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?
Discussion:
Brandontay09
Session 2 would be Event Counter
Bartek
No, answer is correct "event_counter This target counts the number of times that a specific event occurred." "histogram Like the event_counter target, the histogram target counts the occurrences of an event, but can count occurrences for multiple items separately and for both event fields or actions." Histogram works asynch type, and event_counter works sync type. REF: Exam Ref 70-762 Developing SQL Databases Louis Davidson Stacia Varga