Which four Transact-SQL segments should you use to develop the solution?

DRAG DROP
You are tuning a database named MyDatabase.
You need to create an Extended Events session to capture execution plans for queries that run for at least 10 minutes. The following requirements must be met:
The target must write complete buffers to disk asynchronously.
The system must retain a maximum of 10 files
Each session must allocate no more than 10 megabytes (MB) of memory for event buffering.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-
SQL segments to the answer area and arrange them in the correct order.
Select and Place:

microsoft-exams

2 thoughts on “Which four Transact-SQL segments should you use to develop the solution?

  1. I would go for the post event because that allows you to make a better diagnosis. The remark about the performance overhead is true for both the pre and post event: this is mitigated by filtering on duration.

    1. I agree. Query_pre_execution_showplan does not contain a duration field.
      Correct answer is 2, 1, 3, 4.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.