Extended Events Quiz

Quiz covering Performance Monitoring

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   Which component in SQL Server Extended Events is responsible for defining the specific data points to be collected when an event fires?

2. 2

   You need to capture only those queries that take longer than 500 milliseconds to execute. Which Extended Events component should you use to achieve this filtering?

3. 3

   Which target is best suited for viewing Extended Events data in real-time within SQL Server Management Studio (SSMS) without writing T-SQL queries?

4. 4

   When configuring an Extended Events session, what is the primary advantage of using the 'event_file' target over the 'ring_buffer' target for long-running traces?

5. 5

   You are troubleshooting a high-concurrency environment and notice that your Extended Events session is causing significant performance degradation. Which configuration setting is most likely to mitigate this impact while still capturing data?