Which settings should you use?

HOTSPOT

You have a database named DB1. Users report that queries that use a specific table take a long time to complete. You suspect an issue with how often checkpoints are issued.

You need to create an Extended Events session to monitor the database checkpoint activity on DB1.

Which settings should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

References: https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/targets­for-extended-events-in-sql-server